Row level data:

 

ID               Job#     Activated    Revoked

 

121345       19            False         True

121345       34            True          False

121346       35            True          False

121347       36            True          False

121347       42            False         True

 

 

The Activated and Revoked columns are counted if they are true.

The group level is based on the ID field.

 

 

Activated:  3

Revoked:   2

 

--The group level totals are correct (above).  It is just when totals are created without the grouping is when I am getting all records evaluated instead of the grand totals of the group level totals as shown below...

 

Total Activated:  98

Total Revoked:   209

 

This may not be possible using running totals or any other way.  The group sub totals were created in the group footer that is also suppressed with a condition of the ID field that uses a shared variable.  The group footer is suppressed  if the ID field is an empty string, as ( ID="").  I believe this conditional suppression is allowing for me to see the correct values in the sub totals. 

 

Unfortunately, I cannot do the same for the grand totals that are located in the report footer as this would suppress the entire footer.  The ID field is populated with data from a subreport that must use the shared variable.  I believe that is my issue.

 

If you can think of any work-around or trick that would be wonderful.

 

Formula #1:

IF {table.activated}=True and table.id<>"" then 1;

 

Formula #2:

whileprintingrecords;

global numbervar activatesum;

activatesum :=activatesum + (name of Formula #1);

 

Formula #3: