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.