Set the default data properties for each type of data,
including text, number, currency, percent, date, time, date/time,
and time interval.
Procedure
- From the Data menu, click Default
Data Formats.
- In the Format type box, click a
format type.
The properties that you can set for the selected format type appear
in the Properties box.
- If you clicked the Currency format type and require different currencies in the report, click the add button
and select currency check boxes. For example, you may have one column with values are in euros and another column whose values are in US dollars.
- Set the properties.
If you added currencies in step 3, click each one and set the properties.
If you did not add any currencies, any properties you set will apply
to all currencies.
For properties in which you type meta-characters that represent
certain types of information, such as YYYY-MM-DD for dates, the meta-characters
that are required depend on the authoring language specified for the
report. For more information, see Using Patterns to Format Data.
If you set a value for the Pattern property,
all other formatting properties are ignored with the following exceptions:
- Missing Value Characters
- Zero Value Characters
- Negative Pattern
Some properties are language-sensitive and should be changed only
with caution.
Results
The data formatting properties you set are applied to objects
only in the current layout. If a data item contains values in multiple
currencies but only a subset of those currencies have defined formats,
the default format for the locale in which you are working is applied
to values with no specified format.
