Filler Zeros in CR9 1

[szaunbr]

I am working on a report and I need a number field to be exactly 6 digits long. If the number is smaller than 6 digits, I need filler zeros before it.

How do I do this?

 

[synapsevampire]

One approach is to use:

whileprintingrecords;
Stringvar MyFld:= totext({table.value},0,"");
picture(MyFld,"000000")

Looks about right...

-k

 

[lbass]

You can use:

totext({table.number},"000000")

-LB

 

[szaunbr]

Thanks. That works.

Just wondering though, is there any way to do this without changing it to text?

 

[lbass]

Not that I'm aware of.

-LB