Default Formatting Preferences

Default Formatting preferences specify default data formatting for all subsequently created reports. Options are organized by their ability to amend, format, or replace data returned from the data source.

Table 1. Default Formatting Preferences

Formatting Options	Description
Leading and Trailing Formatting
Currency Symbol	Inserts the following currency formatting symbols into the Positive Prefix and Negative Prefix text boxes: Dollar ($), Cents (¢), Pound (£), Euro(E), Deutschmark (DM), Franc (F), and Yen (¥).
Positive Prefix	Character to precede positive numeric values
Positive Suffix	Character to follow positive numeric values
Negative Prefix	Character to precede negative numeric values. Warning: The minus sign (-) is the default prefix. Deleting the default prefix without replacing it causes negative values to display positively.
Negative Suffix	Character to follow negative numeric values
Numeric Formatting
Grouped Thousands Check Box	Numeric digits grouped by thousands
Minimum Decimals	Minimum number of decimal places to display
Maximum Decimals	Maximum number of decimal places to display
Scale	Abbreviated values by tens, hundreds, thousands, ten-thousands, hundred-thousands, millions, and billions.
Use Negative Color Check Box	Negative numbers are signified by a selected color
Select Negative Color	Color representing negative values
Samples
Update Samples	Updates the samples panel based on the most recent formatting selections
Replace Missing With	Replaces missing values with either a text string or zero