Use the Column Details window to define formatting attributes for individual columns in a report. In the Column Details window, you can define:
Column title printed in the report
Column length
Column ordering
Date and number format masks
Currency code
Presentation of number values
All changes are optional and depend on your reporting needs. The Format Mask field is for date and number columns only. The Currency Column field is for currency columns only. The Precision, Minimum Accountable Unit, and Units fields are for number columns only.
Note: You can only enter a value in one of these fields for any given attribute set.
The Sum and Count check boxes in the Column Details window are display only. To define summed or counted columns, and to change the level at which summed or counted values are printed, navigate to the Summary Details window by selecting a column and pressing the Sum or Count button. See: Defining Summary Columns for more information.
To define column formatting:
Navigate to the Attribute Set window.
In the Report Name field, choose the RXi report that you want.
In the Attribute Set field, enter the attribute set that you want.
Navigate to the Column Details window by pressing the Column Details button.
The Level field displays the grouping level for each column. The Column Name field displays the interface table column name for each column.
In the Attribute Name field, enter a new column heading.
In the Length field, change the length (in characters) of a column.
Note: A column heading longer than the value that you enter wraps to the next line. Column data in a report that is longer than the value that you enter is truncated.
In the Ordering field, enter one of these values for each column:
Ascending - to print column values in ascending order
Descending - to print column values in descending order
None - to print without ordering column values
Note: You must order the values in breaking columns.
In the Format Mask field, enter your own date or number format mask for a column, for example, YYYY-MM-DD for dates or 9.999.990,00 for numbers.
Number format mask - If you want to enter your own number format mask, make sure that the format mask is less than or equal to the value in the Length field, and that the number format is long enough to accommodate the length of number values in your reports. If you enter a number format mask, the report does not use the Currency Column, Precision, and Minimum Accountable Units fields.
Date format mask - The default date format mask is taken from the Default Format tabbed region of the Attribute Set window.
In the Currency Column field, enter the column name from the interface table that contains the currency code, if this column is a currency column.
The currency column in the interface table is used to correctly format column values. For example, USD (US dollars) values use two decimal places, while JPY (Japanese yen) does not use decimal places.
Note: If you enter a value in the Currency Column field, the report does not use the number format mask or the Precision and Minimum Accountable Units fields.
In the Precision field, enter the number of decimal places used to print number values.
For example, if you enter 3, the report prints the number 1.23456 as 1.234. The report does not round up the last decimal place.
Note: If you enter a value in the Precision field, the report does not use the number format mask or the Currency Column and Minimum Accountable Units fields.
In the Minimum Accountable Units field, enter a minimum accountable unit to format numbers.
A minimum accountable unit truncates numbers in the column to multiples of the value that you enter. For example, for a column displaying stock prices in units of 1/16, enter .0625.
Note: If you enter a value in the Minimum Accountable Units field, you cannot use the number format mask or the Currency Column and Precision fields.
In the Units field, specify the basic display unit for numbers.
For example, if you enter 1,000,000, the number 2,345,000 is printed in the report as 2.345. You can also use the Units field in conjunction with the Precision field. For example, if you specify a precision of 1, then the number 2,345,000, with a basic display unit of 1,000,000 prints as 2.3.