Good Day,

I am banging my head against the wall trying to figure out how to format my report. I am sure this is something easy to do, but for the life of me, I am stuck!

I am using CR XI.

Here is the report format:

GH1 Affected Service: Database
GH1 Affected Service: FKK APPLICATIONS
GH2 Affected CI: BISS
GH3 IM001234 (6)
GH2 Affected CI: MAINTOWN
GH3 IM001235 (2)
GH1 Affected Service: FKK BUSINESS
GH2 Affected CI: ALLIANT
GH3 IM001236 (2)
GH1 Affected Service: FKK MS OFFICE
GH1 Affected Service: FKK NETWORK
GH1 Affected Service: FKK OS

How I would like the report to look:


GH1 Affected Service: FKK APPLICATIONS
GH2 Affected CI: BISS
GH3 IM001234 (6)
GH2 Affected CI: MAINTOWN
GH3 IM001235 (2)
GH1 Affected Service: FKK BUSINESS
GH2 Affected CI: ALLIANT
GH3 IM001236 (2)

I don't want to see the Group Headers in GH1 that have no information in GH2 or GH3.

I don't know how to suppress the GH1!

Help!!
Any help is greatly appreciated.

Hi there,

Thank-you for taking the time to reply to me.

The report has the first group of Affected Service. The second group is the Affected CI the third group is the number of tickets for the Affected Service and Affected CI.

The suppress a blank section does not work because there will always be a list of affected services for this report.

In an ideal world, I would be able to set up a formula like
if Group(Affected CI) is null then True.

Thanks again for your help!