Suppress Group and Details Based off Detail Records

[GMAN33]

Hi All

Crystal Reports XI
Oracle 10g

I receive patient pages for a study and the visits for each subject could have 2 to 20 pages per visit.

When a page is received for that visit, it is marked as RECEIVED

So data could look like below

SUBJ VISIT PAGE RECEIVED
101 1 12 Y
101 1 13 N
120 1 12 N
114 1 40 Y

Now not all subjects will receive pages for each visit. So I would like to suppress the visit group if none of the records have a Y for being received just for that visit...but show all of the other visit groups if there is at least one Y as having a received page

My report is currently grouped by SUBJECT and then VISIT with the page name, number, received fields in the details section

Hope I provided enough details and thank you for the assistance

 

[Madawc]

Have a formula field at detail level

if {page.received} = "Y" then 1
else 0

Do a summary count of @PageYes for the group.

Choose Report > Selection Formulas > Group. Only show the group if the summary count is greater than zero.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP