Suppress All Detail Lines Except Last Two Per Group

[RoMarcus]

CRXI R2 / Oracle 10

group1 - part number
group 2 - serial number
details - all historical records that fit search critera sorted by date

Only want to show the last two records - - currrent historical record and the record prior....

I created a running total which gives me the total records each time serial number changes -

what I want is this...


details section expert - suppress.....

{#count}<maximum({#count})-2


this is not working...

appreciate all suggestions....

 

[lbass]

Try:

{#count} < count({table.field},{table.serialnumber})-2

-LB

 

[RoMarcus]

I knew it was something simple - thank you. Works perfectly.