Q:

How to Remove Unwanted Zeors From Decimal Numbers In Crystal Reports

In My Crystal Report, I have three type of decimal numbers.
 1) 11.00 , 2.00

 2) 2.50, 1.30

 3) 11.75, 2.25 

I need to format those 3 types as following
 1) 11, 2

 2) 2.5, 1.3

 3) 11.75, 2.25

That means I want to remove unwanted zeros from my decimal numbers. How can do it?

A:

right click the field on the report canvas  
select format field 
select number tab
select custom style  
select customize 
Next to decimal select the X-2 box and enter the following formula
numbervar dec := 9; 
numbervar i;
numbervar j := dec + 1;
numbervar x;

for i := 1 to j do (
if val(right(totext(currentfieldvalue,j,""),i)) = 0 then
x := j  - i);
x

below that select the X-2 button next to rounding and enter this formula
numbervar dec;

