4.4.3 Adding a Format to a Data Field
To associate a data format with an attribute (column) at the model level or query level, follow the steps below:
1. For a data model, open the model for editing, and click the button in the 'Format' column corresponding to the desired attribute.

For a query, open the query for editing, and select the desired field in the 'Query Fields' panel. Then click the 'Format' button in the 'Editor' panel.

This opens the 'Format' dialog box shown below.

2. In the 'Format' dialog box, select the desired formatting option. The options are the same as those available in the Format tab of the Style Studio. (See Formatting in Report Design.)
For date and number formats, you can specify an optional format pattern string. The date format pattern must conform to the patterns specified by the java.text.SimpleDateFormat class. For example, to format a date as 'Jan 01, 2000', use 'MMM dd, yyyy'.
Decimal formatting only applies if the value is a numeric type.
The number format pattern must conform to the patterns specified by the java.text.DecimalFormat class. For example, to add commas to a number, use '#, ###, ###. ##'. A '#' will show a digit if needed, and a '0' will display zero if the digit is not needed. Adding a '%' at the end of the format will multiply the value by 100 and display as a percentage.
| << Adding Auto-Drilldown to a Query | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.4.4 Extending a Logical Model >> |