fixed length field in Crystal Reports v10 1

[lymi6977]

Is there a way to make a numeric field, i.e. 1234.56, to always have a fixed length of 12 with leading zeros?

1234.56 to be 000000123456

Any help is greatly appreciated!

 

[lbass]

Are there always two decimals? If so, you could use:

totext({table.number}*100,"000000000000")

-LB

 

[synapsevampire]

If the decimal varies, or just to be safe, try:

totext(replace(totext({table.number},0,""),".",""),"000000000000")

-k

 

[synapsevampire]

Oops should be:

totext(replace(totext({table.number},4,""),".",""),"000000000000")

The 4 is the number of max decimals.

-k