Report Studio

Formatting Data

Format data in a report to improve readability. For example, you can show all date values in the order year, month, and day. If you do not set properties here, data is formatted according to the properties set in the model. If the properties were not set in the model, data is formatted according to the International Components for Unicode (ICU) formats.

You can also format data based on a condition or specify the format for a particular object.

To format data:

From the Data menu, click Layout Data Format.
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 . In the Currencies dialog box, select the currencies you want and click OK.
For example, you may have one column whose values are in euros and another column whose values are in US dollars.
Set the properties that you want.
If you added currencies in step 4, click each one and set the properties you want. 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 required depend on the authoring language specified for the report. For more information, see Using Patterns to Format Data.

If you specify 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 locale-sensitive and should only be changed with caution.

Click OK.

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 you are working in is applied to values for which no format is specified.