Avoid sum from adding suppressed fields

[ldejesuspr]

I have a running total(a) in a group field that I suppress when it is greater than 210. In the report footer I have a grant running total for (a). How can i ommit that the fields that were suppressed from getting acumulated?

thanks

 

[synapsevampire]

Presumably you're placing this Running Total into a Group Footer somewhere, and your request is to provide a grand total in the report footer for those that were less than 211.

Create a formula to test and sum the Running Total in the group footer which would look something like:

whileprintingrecords;
numbervar GrandTot;
If {#RunningTotal} < 211 then
GrandTot:=GrandTot+{#RunningTotal}

Then in the report fotter use:

whileprintingrecords;
numbervar GrandTot

-k

 

[ldejesuspr]

I tried your suggestion. When I create the formula I get an error that the field from the running total is unknown although i selected from the list.

I am not an avid user of CR, please assist me more

thanks

 

[dgillz]

Instead of suppressing fields, exclude them from your report entirely with a recrod selection formula.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

Double check your formula. You would get the message "This field name is not known" if you copied SV's formula and then, when replacing {#RunningTotal} with your own running total, you left in an extra "{" or "}".

-LB