Count of Records but NOT Include Records suppressed 2

[rwn]

I need to have a Running Total of Jobs in a Group by Work Center and not include Jobs that need to be suppressed. Then for each change of Group Workcenter to have the count reset to Count Jobs starting at 1.
thank you!

 

[pmax9999]

Set up the Running Total with Evaluate set to Use a formula. The code for the formula should be the opposite to that used in the conditional suppression, eg if the Conditional Suppression formula is {table.feld} = true, the code in the Running Total evaluate formula would be {table.feld} = false (or {table.feld} <> true).

Hope this helps.

Cheers
Pete

 

[kenhamady]

In cases like this where I need to use the suppression logic in several places I will create a formula called "Show Section" and put the logic in it for the rows that should be displayed. Then in the suppression I will say:
not ({@Show Section})

Then you can use "Show Section" in the running total and in any other places where this is used. If you ever need to change the condition it is in one place.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/