Try to increase the width of the field on report.
>Hello, can anyone help me on this.
>
>I have a Select - SQL statement that creates a cursor that is used as the input data for a report. Everything works great except that the report output for one of the fields shows ************. Each of the other fields in the report prints correctly. When I browse the cursor, I find that the field "SalesAmount" is a numeric with 4 decimal places.
>
>The report object property is defined with a format 9,999,999 (although I have tried it without any formating).
>
>I have tried to redefine the SQL to produce data with INT() and ROUND(SalesAmount,0), but I still keep getting the result with 4 decimal places (which is the way the info is stored in the database).
>
>The program is running in VFP 5.0.
>
>I have been working on this problem for most of the day and have gotten nowhere.
>
>Thanks for your help.
>
>Howard Shachter
--sb--