Suppress Rows Conditionally 1

[McNasti]

Hello All:

I'm Runnung Crystal 8.5 against Oracle 8i.

I've created a report that displays the following fields in Details section: Id, Name, Class, Begin_date, End_date

So My data looks something like this:

001, Josh, A, 12/01/99, 02/04/03
001, Josh, B, 03/05/04, 02/06/05
001, Josh, C, 03/05/04, 02/06/05
001, Josh, H, 05/02/06, 08/02/06

Id like to display only the rows that have the maximum Begin_date. So in this case only the following should display.

001, Josh, H, 05/02/06, 08/02/06.

Thanks for your ideas. Pattie

Oh If possible would like to stay away from the use of subreports.

 

[lbass]

Insert a group on {table.ID} and then go to report->selection formula->GROUP and enter:

{table.begin_date} = maximum({table.begin_date},{table.ID})

-LB