At least one record in detail group must match 1

[SgtDan]

I am using Crystal 8. The need is to only display records from a selection group band that have at least one record in detail band that is less than an arbitrary date i.e. "1/1/2002". I created a formula field for max date in the group but I'm having a problem in where to place a formula suppressing grouped records that don't have at least one record less than my target date. Thanks

 

[dtempleton]

Use the Select Expert.

 

[SgtDan]

That was my first thought but there was no ability to "select" on my formula field because the select expert doesn't show or allow the formula to select records

 

[SgtDan]

Sorry, just remembered.. I also filter my group records by those in the group having ten or more incidents.

 

[dtempleton]

What do you have in your formula?

 

[lbass]

Create a formula {@1102}:

if {table.date} < Date(2002, 01, 01) then 1 else 0

Then go to report->edit selection formula->GROUP and enter:

count({table.field}, {table.groupfield}) >= 10 and
sum({@<1102},{table.groupfield}) > 0

Substitute your correct field names.

-LB

 

[SgtDan]

Thanks dtempleton and lbass, problem resolved.