Crystal Reports Select All formula

[chrissypchy]

Hi All,

I was wondering if anyone knew how to write a formula where if all of one attribute has the same value, for example if I had an attribute called "buystatus" and all of the values were equal to zero, I would like to just print once "All Equal to Zero" and print a million times. I hope I am making sense. I'd really appreciate anyone's input.

-Chrissy

 

[JohnEck]

I have no9t tested this but it should work.
Do a record count for the report. Use a formula like this
If BuyStatus = 0 then 1 else 0
Sum the formula. If the formula and the record count are the same suppress the details.

 

[chrissypchy]

Thanks for the help John!! It works.