Duplicate Problem...Sort Of... 1

[ChiTownDiva]

Here's my data:
Session Enr Reserv Seats
DC610-001 E 100016 3
DC610-001 E 100016 3
DC610-001 E 3
DC610-002 E 3
DC610-002 E 3

I have no problem with the way Crystal is pulling in the data--that's the way it is in the database. What I want to do is suppress all but one of the DC610-001--doesn't matter which one without suppressing DC610-002.

I've tried saying if the count of reserv is > 0.

I'm clueless as to how to get rid of one of the "duplicates" without getting rid of all of the records.

Can someone point me in the right direction?

Thanks in advance.

ChiTownDiva

 

[lyanch]

in the detail section you can and in the suppresion formula something along the lines of:

table.session = previous(table.session)

Lisa

 

[ChiTownDiva]

Thanks Lisa, that worked!

ChiTownDiva