How to find total while suppressing records

[kutoose]

I am having an issue with finding the right total in a report. The scenario is like this. I have a report which is grouped. Now I am finding the totals of the fields in the group footer. So far is fine. Now I have to suppress some records in the detail section based on some conditions. I conditionally suppress those records. But in the report footer, I still have the sum of all the records, whether it is suppressed or not. I want the sum of the records not suppressed

 

[synapsevampire]

Create a Running Total and in the evaluate->Use a formula, and basically use the criteria used to suppress, with a NOT() around it. Might take a little tweaking.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com