Group Sort Expert 2

[zenzabar]

Using Crystal XI

I need to show only records that have 6 or more dates of services. Sounds easy....Suggestions?

John Smith
Date of Discharge 7/30/09
Dates of Service
1/1/09
2/1/09
3/1/09
4/1/09
5/1/09
6/1/09

Susie Que
Date of Discharge 5/1/09
Dates of service
2/3/09
4/2/09

 

[SchwabTerex]

I'm not sure what your layout looks like. I assume you will be using a group on name. I would try placing a count in the group footer on dates of service. You could supress the field so it didn't show. That would give you a field to filter by in your selection criteria. Worked on the quick sample I did anyhow.

 

[lbass]

If your field is a date field (not a datetime), you could go to report->selection formula->GROUP and enter:

distinctcount({table.date},{table.name}) >= 6

...assuming a group on {table.name}.

-LB