Show the first line if a invoice has more than a line

nice

If you have referenced your DataItem(s) to actual (not Integer) Table(s) you can do the following...

Of the DataItem/Table that contains the Invoice "line(s)" find the field that remains static or uniquely ties those records to their respective invoice. After you have found this field, apply it to the DataItem's 'GroupTotalFields' property. With this you can then insert a 'Group Header' section in your report with the following code behind it:

(The following code would also be the most ideal method if you only have one DataItem; Where MaxIteration etc is not possible to be utilized)

YourDataItem, GroupHeader (1) - OnPreSection()

  IF CurrReport.TOTALSCAUSEDBY = FIELDNO("Invoice ID Field") THEN
    //Do any calculations etc if you want a custom display
  ELSE
    CurrReport.SHOWOUTPUT(FALSE);

Or if you just want it simple do..

YourDataItem, GroupHeader (1) - OnPreSection()

  CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = FIELDNO("Invoice ID Field"));

A 'Group Header' section will only trigger on the very first findings of the field(s) you have specified in the 'GroupTotalFields' property.

(Important: This will *not* work if the implied field(s) do not have at least some method of sorting applied.)

Yes if DarkHorse does in fact want to display only the first line of the "multiple lined invoices", einsTeIn.NET's example would work.

But why go as far as putting code in two areas of the report if the previous area's code can be easily applied in the latter area:

(MaxIteration = 1)

DataItem - OnAfterGetRecord()

  IF COUNT = 1 THEN
    CurrReport.SKIP;

('OnAfterGetRecord' implies a record has been retrieve therefore you wouldn't need to specify '<=', correct?)