How to do formatting on numbers in Crystal Report?

[Shailja]

Hi,

I have designed one crystal report. I have one column in it, Gross Amt. When I run it, values are displayed in following format.

GrossAmt
---------------
10,000.65
1,000.85

Instead above format, I want to display in following format.
GrossAmt
---------------
10,000.65
01,000.85

How to do it? Kindly let me.
Thanks

[coolminded]

Hi,

I have designed one crystal report. I have one column in it, Gross Amt. When I run it, values are displayed in following format.

GrossAmt
---------------
10,000.65
1,000.85

Instead above format, I want to display in following format.
GrossAmt
---------------
10,000.65
01,000.85

How to do it? Kindly let me.
Thanks

hi shailja
for your problem, just use the function lpad()
for ex, if u need to make 1000.85 to 01000.85 then
the code for this is
lpad('1000.85','8','0)

it's out put will be
01000.85

8 means the no length of number,i,e.' 01000.85' and 0 means the number to be inserted in the front of the number.