Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Thousands separator
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00131213
Message ID:
00131256
Vues:
18
>>>I can't find a way to print the thousands separators in the reports.
>>>The SET SYSFORMATS doesn't seem to work neither the SET SEPARATOR.
>>>I'll appreciate any help. Thank you.
>>
>>Eduardo,
>>
>>Go to the field in teh report designer and double click it. In the box marked >Format type 999,999,999.99 or whatever picture you want the field to have.
>
>
>Thank you Jim, but when I use this mask in Format in the report I get ***,***,***.** and I don't really understand why. It is not a problem of the box size.

Eduardo,

That is the result fo a numeric overflow, either the textbox is not wide enough or the field was updated with data that exceeded the set length. It alos occurs when you are totally a numeric and the mask isn't long enough to display the entire number as in;

Number = 1,250,250,250.50
Mask = 9,999,999.99
Result = *,***,***.**

Make sure the mask is long enough for the longest number that will ever appear in the field. If it is a summing field in the report then the mask will likely be longer than the size of the field in the table.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform