Crystal Reports 2008: Suppress Group Header when details are suppressed

Question

I have a report that currently displays data in the following format:

GROUP HEADER
January      Meter Number      Name       Class      Facility ...
...
December     MeterNumber       Name       Class      Facility ...

GROUP HEADER
January      Meter Number      Name       Class      Facility ...
...
December     MeterNumber       Name       Class      Facility ...

I have a conditional suppression formula on the details lines that will suppress a record if one of the fields values is higher than a specific value. Everything works great if I suppress the Group Header line, but I just get a long list of the records that are not supposed to be suppressed. I would like to leave the Group Header visible so the report is easier to read. The problem is that when I add the conditional suppression formula to the Group Header line, it only looks at the first record in the group. If that record is suppressed, then so is the Group Header, but there may be 3 months worth of records that are not supposed to be suppressed so I would still like the Group Header to display. Instead what I get is the following:

March      10003      Name       Class      Facility ... //Notice no Group Header
April      10003      Name       Class      Facility ...
December   10003      Name       Class      Facility ...

Group Header
January    10004      Name       Class      Facility ...
March      10004      Name       Class      Facility ...
February   10005      Name       Class      Facility ...   //Notice no Group Header
March      10005      Name       Class      Facility ...

Due to the January month being suppressed for meter number 10003 and 10005, the Group Header is also suppressed. I tried placing the Group Header on the details line and that works in the since that it prints the Group Header on every line but then I format that field and suppress duplicates and it does the same thing all over again. It only displays those Group Headers where the January record is not suppressed. This wouldn't be such a big deal but I am dealing with 1000+ records after the suppression.

I have searched for two days for a solution to no avail. Is there any way to look at all records in a group instead of just the first record when it comes to suppressing?

EDIT: For those questions as to why I need to suppress the Group Header when all of the details in that meter are already suppressed it's because if I don't then I get the following:

10003
10004
January    10004      Name       Class      Facility ...
March      10004      Name       Class      Facility ...
10005
February   10005      Name       Class      Facility ...   
March      10005      Name       Class      Facility ...
10006
10007
10008...

In other words, I will get a few pages of just group headers before I see one with actual details.

Answer 1

For the sake of illustration, I'm going to assume that the logic to suppress your Details section is contained in the formula {@SuppressDetails?}. Now, create a new formula that outputs a 1 when the section is suppressed and a 0 otherwise:

if {@SuppressDetails?} then 1 else 0

Place this new formula in the Details section and suppress it. Now, create your Group Header suppression formula such that it compares the number of suppressed Details sections to the total number of records in that group (that is, the {table.MeterNumber} group):

count({@SuppressDetails?},{table.MeterNumber}) = sum({SuppressDetails?},{table.MeterNumber})