Numeric Fields
In the Properties window for a numeric field, you specify the format in which to display values in the report. The following table describes the four choices available for Format under Format. All of these choices use the selection for Decimal places under this same heading to determine the number of decimal places to show. For more information, see Format.
The settings specified in the Regional Settings Properties window in the Windows Control window are used for negative amounts and decimal and currency symbols. Values are rounded to the specified decimal place.
Format
Example
Description
Fixed
3456.79
Displays at least one digit. The number of digits shown is always equal to the value specified for Decimal places, padded with zeros if necessary.
General Number
3456.789
Displays the value with the maximum number of decimal places being equivalent to that specified for Decimal places. When this format is selected, trailing zeroes in the decimal places are removed. Also, if no decimal places are needed, the number is printed without the decimal point and any decimal places.
Scientific
3.46E+03
Displays the value in scientific notation.
Standard
3,456.79
Displays the same format as when Fixed is selected except that a thousands separator is used.