>I am using a report that needs formatting of a field as a currency field.This field reads from a table field N(10,2) size.Decimals are set to 2 in regional settings.I need this field in the detail band and also on a summary band with the calculated field using SUM.
>Visual fox5a sets this format as "@$". But on the preview the field displays the number ok but the decimal places are filled up to the size of the field.
>
>Eg if the value is $2345.56 preview shows $2345.56000000. If I reduce the size of the field then the zeros are reduced. If I set up the field as a number (no currency) the decimals come out ok. But for Currency this always happens.
>
>I found that by checking the box "Stretch with overflow" this problem is solved in the detail band and the decimals show only 2 places. But I cannot do this for the Summary band as "stretch..." is disabled.
>
>Is this a bug or what. I cannot find any way around this. The help says that regional settings from the Control panel are used but this is not so as I have only 2 decimals setup here.
>
>Can anyone shed some light on this most frustrating problem.
>I need the report compiled into an exe as that is how it will run.
>
>Thanks
>Bernard
Further from me,Bernard, the tables used are normal fox2.6 tables using a numeric type field NOT VFOX currency fields.