Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Thousands separator
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00131213
Message ID:
00131256
Views:
19
>>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform