Width | Use the width defined in database uses the number of digits defined in the database. User defined defines the number of digits. When you select this option, use the Sample field to define the number of characters to the left and right of the decimal point.
|
Alignment | Select Left or Right alignment |
Separator | Imply decimal points does not print decimal points. For example, the value 106.00 prints as 10600. Delimit thousands delimits the thousands place with commas. For example, 13648123 prints as 13,648,123. (To delimit the thousands place with periods, select the Delimit thousands with periods and decimals with commas option under Special, described below.)
|
Money Sign | None does not print the currency symbol. Float moves the currency symbols with the numbers. For example: Fixed aligns the currency symbols. For example, Right Alignment with a Fixed Money Sign, right-aligns the numbers, but keeps the currency symbols fixed For example:
|
Fill | None does not print any special fill attributes. Zero fill to left prints zeroes to the left of the number as shown below: Show blank if a value is zero prints a blank space instead of a zero when the value is zero.
|
Table Referencing | Forces SQR Production Reporting Studio to disregard table name prefixes in Production Reporting code. |
Special | None: Indicates that you do not want any of the special options listed below. Use scientific format: Use this format for very small or very large numbers. For example Show N/A if a column is null: If a column contains no data, print N/A. The term N/A stands for "Not Available." Show blank if a column is null: If a column contains no data, leave it blank. Delimit thousands with periods and decimals with commas: Print numbers as follows: Show a minus at the right of a negative number: Print negative numbers as follows: Show angle brackets around a negative number: Print negative numbers as follows: Show parentheses around a negative number: Print negative numbers as follows: Show floating parentheses around a negative number: Print negative numbers as follows:
|