Supress a group header if all records in the group are supressed 1

[tman135]

Can anyone tell me how to supress a group header if all of the records in the group are supressed? I've got 300+ records that get supressed correctly within a group, but the group header is still printing thinking there are 300 records there.

 

[synapsevampire]

Perhaps you can create a formula in the details section which has the criteria for suppression and returns a 1 if it's NOT suppressed, else a 0.

Place the formula into the details section, right click and select insert summary->sum.

It will create a summary which you can reference from within the group header to allow for suppression if the value is 0.

-k.

http://www.informeddatadecisions.com

kai@informeddatadecisions.com