Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing if Zero 1

Status
Not open for further replies.

FrequentUser

Technical User
Aug 24, 2006
17
US
Just got CRXI last week, and I am having problems suppressing summaries when result = 0

I have tried making formulas in Format Editor.

Is there something new with CRXI that prohibits this?

Format Editor, Suppress Formula: when . . .
Sum ({@JulyRplan_disp}) = 0

No Errors, but does not suppress those fields = to 0

Crystal Reports XI, MSSQL 2000, ODBC
 
Your formula is a grand total formula. You probably need a group condition:

Sum ({@JulyRplan_disp}, {table.group}) = 0

You could also just right click on the value you want to suppress if zero->format field->number->customize->suppress if zero.

-LB

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top