Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: cross tab- show no zeros in summarized field Post Reply Post New Topic
Author Message
abrown
Newbie
Newbie


Joined: 15 May 2009
Online Status: Offline
Posts: 9
Quote abrown Replybullet Topic: cross tab- show no zeros in summarized field
    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.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
 
 
IP IP Logged
abrown
Newbie
Newbie


Joined: 15 May 2009
Online Status: Offline
Posts: 9
Quote abrown Replybullet Posted: 15 May 2009 at 12:12pm
Wonderful- that is excatly what I was looking for!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.