view latest date only - in group 1

[prigro]

I have a report where items are grouped by the part number. The data contains only processed transactions, meaning there are only entries up until the present date. From each of these groups I want to view only the record with the most recent(last) date. Is there any way to do this?

 

[bjrollet]

Sort you report detail (where the dates are listed, as descending). Then create a formula field and place the following in it:

whileprintingrecords;
numbervar counter;
counter:=counter+1

Next, place the formula field in the detail section.

Next, click 'Format' on the menu bar, then select 'Section'. Choose the 'Detail' section and place the following code in the 'Suppress (No Drill-down)' event (click on the X+2 button next to it):

(WhilePrintingRecords;
NumberVar counter;
  counter > 1)

That should do it!

 

[prigro]

Thanks a lot
It worked perfectly!