One To Many Relationship 1

[govmule]

Hello,

I am running Crystal Reports 8.5 connected via Native Drivers to Informix 7.3 Dynamic Server.

Each client has one application. Most clients have one case, but some have two. The app table and the case table are joined by the app number (it exists in both the app table and the case table).

I want to identify only those records that have multiple cases attached to one application.

Any ideas?

As always, Thank You

Jack Luster

 

[synapsevampire]

Group by the Application

In the Report->Edit selection formula->Group place something like:

count({table.case},{table.application}) > 1

-k

 

[govmule]

Thanks a million! Worked like a charm!