Suppressing Detail Records > 1

[TEM3]

Using CR 8.5/Oracle 9i.....

The vast majority of items receieved in a case and worked on by a section result in a line item on one report. However some items end up on more than one report from the same section.

I have a report that is grouped on cases and then items. For each item the Report # that is/are associated with that item are listed. I want to suppress everything (case group, item group and report detail listing) if a case contains only items with one report record.

How can I suppress my groups (and the detail section) if only one report is found for an item?

My report prints like the below:

S06-00043 (Group 1)
Item # 1 (Group 2)
Report # 1 01/24/2006 (Details)
S06-00053
Item # 1
Report # 1 01/06/2006
Report # 3 01/24/2006

In the above, I would want to suppress all of S06-00043 and only want to see cases like S06-00053. BTW, the report number not a sequential count. It is a number assigned by the system as Case Reports are generated independent of the section. The above report is filtered for items examined by one particular section.

 

[lbass]

Instead of suppression, try group selection. Go to report->selection formula->GROUP and enter:

distinctcount({table.reportno},{table.case}) > 1

-LB