Subreport question

[cjany]

My main report pulls court cases set on a given date and in a given court and the records are grouped by participant ID. My subreport pulls other cases related to the same Participant ID. Currently, my report shows all cases whether the participant has others case or not.

I do not want to see the cases on my report if the participant only has one case. I only want to see if they have other cases.

Any suggestions?

 

[Turkbear]

Hi,, Is there some other reason you are using Sub-Reports?
If not, then use just a main report and link the table with the cases to itself, by whatever the key field is..

Then have it group by Participant ID - you can then have it supress the group and its details if the Count(caseID) < 2







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

You can't suppress on the basis of data found in a subreport. You can return the result using a shared variable, but the value cannot be used until the next section down.

Like Turkbear, I wonder why you need a subreport. You could add cases again, as an alias, and make the link using Participant ID. If the link is Equals rather than Left OUter, this would automatically exclude those with just one case.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10