Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formating a number
Message
From
09/04/2003 02:26:32
 
 
To
07/04/2003 13:08:18
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00774780
Message ID:
00775356
Views:
12
Frederico, you do not say what format you want the output to be when the value is 22? If you want leading zero's or spaces then you can try:
nAccount = 22

* This will output 00.00.00.022
? PADL( TRANSFORM( nAccount ), 12, "0" ) PICTURE "99.99.99.999"

* This will output   .  .  . 22
? PADL( TRANSFORM( nAccount ), 12, " " ) PICTURE "99.99.99.999"
The "12" in the PADL() function is the length of the PICTURE clause.


>Hello *.*
>
>I´m using Crystal 9 to do an account report, these accounts has a format like: XX.XX.XX.XXX but if the number is 22 (for exemple) It print 22. . . when I use the PICTURE function. What´s wrong ?
>
>Thanks in advance.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform