Show many lines in report

lilianatavares

Hello!

I want to show in a report all the records of Customer X that you are in Table Cust. Ledger Entry.

In the trigger Customer, GroupFooter - OnPreSection () I write:

" Cust. Ledger Entry ".SETFILTER (" Cust. Ledger Entry "."No. ", No. ");
IF " Cust. Ledger Entry ".FIND (' - ' )THEN;

It is the report it only prints the first record.
How can I do for him to print all the record's?

Thank's

facade

I don't exactly understand what you are trying to accomplish but do you have a report with tables ?

DataItemTable=Table18;
ReqFilterFields=No.;

and

DataItemIndent=1;
DataItemTable=Table21;
DataItemLink=Customer No.=FIELD(No.);

If so then you don't have to code it since Dataitemlink does the job.

Tõnu

lilianatavares

Hello,

Simplifying, I want is to see all the records that the filter comes back through code.

For example:

Record.SETFILTER(Record.No,'<>%1',No);
IF Record.FIND('-')THEN;


Thank's

bostjanl

lilianatavares wrote:

Hello!

I want to show in a report all the records of Customer X that you are in Table Cust. Ledger Entry.

In the trigger Customer, GroupFooter - OnPreSection () I write:

" Cust. Ledger Entry ".SETFILTER (" Cust. Ledger Entry "."No. ", No. ");
IF " Cust. Ledger Entry ".FIND (' - ' )THEN;

It is the report it only prints the first record.
How can I do for him to print all the record's?

Thank's

Hi!

With this filter you filter CLE entry number and customer number.

I think that you should filter " Cust. Ledger Entry ".SETFILTER("Customer No.","No.") if you want to filter all CLE of customer.

And if you want to print those CLE, then you have to have a DataItem for that. Have you DataItem? And you can set "filter" in dataitem's properties.

Sample picture

Bostjan

bostjanl

lilianatavares wrote:

Hello,

Simplifying, I want is to see all the records that the filter comes back through code.

For example:

Record.SETFILTER(Record.No,'<>%1',No);
IF Record.FIND('-')THEN;


Thank's

Hi!

Or you want just loop the recordset?

Record.SETFILTER(Record.No,'<>%1',No);
IF Record.FIND('-')THEN BEGIN
REPEAT
// Your action here
UNTIL Record.NEXT = 0;
END;