PRB: Report Writer Rounds Numeric Values

ID: Q128892

The information in this article applies to:

• Microsoft FoxPro for Windows, version 2.6a

SYMPTOMS

The Report Writer rounds numeric values when the field on the report is physically smaller than the original size of the field.

CAUSE

When the field size is not too small (where the field cannot hold the size of the numeric value) but the field is not large enough to hold the complete value, the Report Writer rounds the value.

RESOLUTION

1. Increase the physical size of the field on the report.

2. Leave the field the original size created by the Report Writer, but

   reduce the font size when more space is needed horizontally.

   wrap to the next line.

STATUS

This behavior is by design.

MORE INFORMATION

In the Report Writer, if a field is too small to contain a given value, the field will contain asterisks to indicate numeric overflow. However, before this point is reached, you can decrease the size of the field and the Report Writer will round the number to fit it into the smaller field.

Steps to Reproduce Behavior

1. In FoxPro, create a new report.

2. In the Report Writer, Open the Customer table.

3. Add the ytdpurch field to the report, and set the font to Courier New,

   size 10)

   only "ytdpur" is displayed in the field box.

   only "ytd" is displayed in the field box.

    - The original field displays the proper value from the Customer table.

    - Some of the values in the second field are rounded (all values in the
      thousands range).

    - Most of the values in the third field are asterisks (values in the
      thousands) with the remainder of the values rounded.