Using "Maximum" for a Record

[shelby55]

Hello

I have a 2002 Access Database and I use Crystal 9.0.

I have a patient database and I'm grouping on health card number (unique to patient) and calculating # of visits per Health Card Number. To show current age I'm selecting "maximum" of age because I want the age from the most current visit (the report will show up to 4 years of data) which works great.

However, how do I show the most recent data for elements that might not always be in the database? I want diagnosis and city as it shows on the most recent visit.

Any and all assistance greatly appreciated!

 

[lbass]

You could use group selection (report->selection formula->GROUP):

{table.date} = maximum({table.date},{table.cardno})

This would display ONLY the record for the most recent visit, but the other records would still be in the underlying data, so you could insert a count on cardno to get the number of visits (assuming a count provides correct results before group selection).

-LB