suppress all if group total = zero

[atarrqis]

CRII and Oracle
I have 2 groups. I sum at group2 & group1. I want to suppress all the details if group1 sum = 0. I've tried both running total and numbervar without success. Too simple?

 

[atarrqis]

exmaple:
ABC -12
ABC 10
ABC -2 Group2

BCD -4
BCD 6
BCD 2 Group2

0 Group1

all lines should be suppressed

 

[CoSpringsGuy]

From menu - Report-section expert
In suppression formula enter

sum({Yourfield},{group1field}) = 0

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[atarrqis]

Well, yes, I tried this but it doesn't suppress the details. I assumed it had something to do with when it computes the total of group1 vs when it reads the details.

 

[IdoMillet]

The menu option of
Report, Selection Formulas, Group...
is exactly what you are looking for.

Cheers,
- Ido


view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[atarrqis]

I tried using Selection..Group but this didn't work.
I realize now I had an error in that formula. Once I fixed, it worked great.
Thanks!

 

[CoSpringsGuy]

IDOs solution is better than what I suggested by the way

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection