Hi to all, it’s a pleasure to write into this forum.

Referring to the above object, I looked for an answer into the web but without success. But I’m a newbie in this forum and maybe I did not get it. Well, below detailed the problem.

I have a report (made with CR XI, based on a sql View, linked to a SQL Server 2008 database) that is structured like:

GROUP HEADER 1

                GROUP HEADER 2

                               DETAIL1

                               DETAIL2

                               […]

                GROUP FOOTER 2

GROUP FOOTER 1

The report works fine but I can’t understand what I have to do to achieve those two goals:

1) I have to suppress Group header 2 when all its details are suppressed;

2) I have to suppress Group header 1 when all “its” group header 2 are suppressed.

This report shows to the user a customer list (detail) grouped by Macro Territorial Zone (group 2) and Financial Agent (group 1). Nearby each customer is placed its own account balance.

The report can be used by an external program which sends values to valorize some formulas inside the report. Through this way, users can choice if print or not customers with a “zero” account balance.

In the Detail’s Report Expert Section I put a control in the Suppress Formula that will suppress a detail if the account balance is zero, while user chose to suppress customer with a zero account balance.

But now, how can I get the first goal? And what about the second?

The report works fine but I can’t understand what I have to do to achieve those two goals:

1) I have to suppress Group header 2 when all its details are suppressed;

2) I have to suppress Group header 1 when all “its” group header 2 are suppressed.