Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Asterisks in Report Field
Message
 
 
To
08/08/2002 18:10:00
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00687753
Message ID:
00687760
Views:
12
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform