Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formating a number
Message
De
09/04/2003 08:00:13
 
 
À
09/04/2003 02:26:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Crystal Reports
Divers
Thread ID:
00774780
Message ID:
00775411
Vues:
18
Jos, I need something like this:
1           Level 1
1.1         Level 2
1.1.1       Level 3
1.1.1.1     Level 4

*My table contain these fields:

ID_Level        Name_Level
1               Level 1
11              level 2
111             Level 3
1111            Level 4
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform