Link to home
Start Free TrialLog in
Avatar of Michael Katz
Michael KatzFlag for United States of America

asked on

Only show decimals when there are non zero decimals in Crystal Reports

I have a number field that may be 1.00 which I only want to show 1..
but if its 1.05 I want it to show 1.05

Any ideas??
Avatar of James0628
James0628

Do you want the values aligned at the decimal point?

 If you use the usual right alignment and simply remove the decimals, you end up with values like this:

   1
   2
3.50
   4
5.25
   6

Open in new window


Also, do you want to always display 2 decimal places on non-integers, or only display the required number of places?  For example, should 3.5 be shown as 3.50, or just 3.5 ?

 If you want to always display 2 decimal places on non-integers, you can go to the field format, click Customize on the Number tab, click the formula (X+2) button beside Decimals and enter this formula:

if CurrentFieldValue = Truncate (CurrentFieldValue) then
  0
else
  2


 Rounding would presumably be set to 2 places.  You could use the same formula for Rounding, but it doesn't seem necessary, since you're only hiding the decimals when they're 0.

 James
SOLUTION
Avatar of Michael Katz
Michael Katz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try this one
Right click the field
Click FORMAT FIELD
Click the NUMBER TAB
CLick the formula button to the right of Decimals
Enter this formula
If {YourFIeld} = Round ({YourFIeld}) then
   0
Else If {YourFIeld} = Round ({YourFIeld},1) then
   1
Else If {YourFIeld} = Round ({YourFIeld},2) then
   2
Else
   3

Click OK
Set Rounding to 0.001

mlmcc
Avatar of Michael Katz

ASKER

Which formula button to the right of the decimals??
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Concise and well done... Pretty straightforward from both of these guys...Par for the course with James and mlmcc