Suppress Group Header Based on Record Returned

[Garyjr123]

How do I go about suppressing a group header based on a record returned?

I wrote a report that uses 3 group headers

GH1 service.abbr
GH2 appt.start_datetime
GH3 appt.appt_id
Da subreport
Db subreport

In the Suppress formula (X-2) of the Details and GH3 section of the Section Expert I added a formula isnull({resind.class}). I return only records that have something in the resind.class field.

Now, I want to return only the GH1 {service.abbr} if rows are returned for the formula above. Everytime I try to suppress this GH1 in Section Expert (X-2) with formula of isnull({resind.class}) the report only returns one group header and since I'm grouping on multiple services, I want all the new GH1 services to show up with rows in them.

Gary

 

[lbass]

Are you saying you want GH1 to be suppressed if all rows within Group 1 are suppressed? If so, then use a suppression formula like this:

isnull(maximum({resind.class},{table.group#1field}))

-LB

 

[Garyjr123]

LB,

That is exactly what I'm saying. I'm not sure what {table.group#1field} is supposed to be. Can you explain a little more what field I'm supposed to be dropping in here?

Gary

 

[lbass]

The field you are grouping on for Group #1.

-LB

 

[Garyjr123]

LB,

That worked perfectly. Thanks again!

Gary