Suppressing details

[savok]

I have 2 fields on a report. Name and Progress Notes. Progress Notes repeat and I only need to show the lastest notes.

How would I do that?


I know I would sort on something and then put some formula in the suppress code but what?

thanks

 

[savok]

forgot to mention there is also an ID that counts Progress Notes for each Customer. So if there were 5 notes, the ID would go 1, 2, 3, 4, 5. So I need to put in the formula where ID is the Highest (5 in this case).

How would I do that?

thank you

 

[jonbrown]

Tick the Suppress check box in the format section expert, and enter the following in the formula:
IF 'NOTE ID' = 5 THEN
FALSE
ELSE
TRUE

this will suppress the row unless the ID = 5

 

[balves]

Group by customer, suppress unless the Note Id = Max(Note Id). Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[IdoMillet]

You could also Group on Name, sort on ID within it,
place the info you need in the group footer (shows for only the last record in the group) and suppress the detail.

Cheers,
- Ido ixm7@psu.edu