Print Page | Close Window

cross tab- show no zeros in summarized field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6369
Printed Date: 30 Apr 2024 at 4:41pm


Topic: cross tab- show no zeros in summarized field
Posted By: abrown
Subject: cross tab- show no zeros in summarized field
Date Posted: 15 May 2009 at 11:39am

Hi,

I am new to Crystal 2008 and I have a Cross Tab report. In the cross tab I have a number field that is in the Summarized section. If the result is 0 than I want it to show an empty cell. I am having trouble with the field types.
 
I tried an If- Else- Then statement but it converts it to a string becuase I am telling it to leave the cell blank (""). Once it converts to a string the Cross Tab Summarized section does not allow me to SUM the field.
 
How can I eliminate all zeros easily and keep it a numeric field?
 
If {OrdDet}=0 Then
""
Else
totext({OrdDet},0)
 
Thanks.


Replies:
Posted By: DBlank
Date Posted: 15 May 2009 at 12:09pm
In the crosstab, right click on the field you want to suppress if it is zero and select Format Field.
on the Numbers Tab click on Customize.
On the NUmber tab mark the check box for "Suppress if Zero".
(Make any other format changes you need here as well)
Save and close.
Should be suppressed.
Note that you have to suppress Totals seperately from regular summary fields.
 
 

Posted By: abrown
Date Posted: 15 May 2009 at 12:12pm
Wonderful- that is excatly what I was looking for!


Print Page | Close Window