>>>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.