To get Total of dispayed records only

[kambike]

Hi,

I am suppressing groups based on a condition, I want to show summary in the footer for these records only. If I use the normal summary function then I get the sum of all the records, including those that are suppressed. How do I do it?

Regards,
KA

 

[Prefect]

Create a formula to flag each record. Set it equal to 1 if it meets the display criteria, 0 if it doesn't. Then, SUM the formula field.

 

[kenhamady]

You could also put the opposite of your suppress condition into the Group Selection Formula. Then a running total will only inlcude the printing groups. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/