Show many lines in report

Comments

• Options

  facade Member Posts: 57

  2004-07-21 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

  0
• Options

  lilianatavares Member Posts: 39

  2004-07-21

  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

  0
• Options

  bostjanl Member Posts: 107

  2004-07-21

  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

  0
• Options

  bostjanl Member Posts: 107

  2004-07-21

  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;

  0