Show many lines in report

lilianatavares
lilianatavares Member Posts: 39
edited 2004-07-21 in NAV/Navision Classic Client
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

Comments

  • facade
    facade Member Posts: 57
    edited 2004-07-21
    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
    lilianatavares Member Posts: 39
    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
    bostjanl Member Posts: 107
    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
    bostjanl Member Posts: 107
    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;

Categories