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