Filtering on Running Total Possible? 1

[BettyM]

I am working in CR 8. Is there any hope of filtering on a running total? For example, if RunningTotalofSumA > 0 then print the group footer.

 

[dgillz]

Assumming the value of A is not zero or negative, this will always happen. What are you trying to do exactly? Are you trying to exclude certain groups? More detail please.

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

http://www.trianglepartners.com

 

[kenhamady]

You can't really 'filter' on an RT because the filtering happens long before the RTs are calculated. But you can create the illusion of filtering by suppressing the GH for groups that don't meet your criteria. The data is still there in memory, but you don't see it.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[BettyM]

Sorry didn't clarify enough for anyone to really help me.

My whole report is a group footer . . . everything else is suppressed. The group I have is the unique file number which contains this running total. My running total answer will always be either 0 or 1.

Need to print or not print the entire group footer based on my running total answer.

Is there a conditional printing formula which allows me to do this? If so how do I establish it around my footer?

 

[kenhamady]

Go into the section expert (format section) and highlight this section. There is a suppress property that can be given a condition.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[BettyM]

Thanks Ken . . . it worked.