SURPRESSING ZERO FIELDS IN CRYSTAL REPORTS

[jorg32]

Hello,

Can somebody tell me how to surpress the following :

E.G. = 150.00 euro has to be 150
150.75 euro has to stay 150.75

So every time I have a double zero behind the comma, I have to surpress them (double zero's only!!)

Thanks for helping me!!

 

[bdreed35]

Right click the field on the report.
Choose Format Field.
Click the Number tab.
Click the Customize button.
Under the Number tab, click the X+2 button to the right of decimals.
In the editor, enter the following logic:

//don't modify this.  CurrentFieldValue is a crystal built in function
if CurrentFieldValue - int(CurrentFieldValue) = 0 then
    0
else
    2

Save and Close and the dialog boxes and test it.

~Brian