Table 7. Siebel Answers Column Formatting Option Fields
Field
|
Description
|
Table Alias (Heading)
|
Type the name you want to display in the results. To access this field, you must select the Custom Headings option. The heading name you specify affects only the selected column. Other columns in the same subject area are unaffected.
|
Column Alias
|
Type the column heading name you want to display for the column. To access this field, you must select the Custom Headings option.
|
Custom Headings
|
When selected, indicates that the custom headings you type for the column will be used in the results. When cleared, indicates that the original headings associated with the column will be used.
|
Visibility
|
Indicates whether to display the column in the results. You can add multiple columns to a request to help sort, total, and format the data within the results; however, those columns do not have to be displayed.
You can display only those columns with data that you need. By default, all columns are set to Display when they are added to a request. Columns that are hidden are still used by the request; however, they do not appear in the results.
|
Alignment
|
Aligns the column values to the left, center, or right of the table cells.
|
Vertical Alignment
|
Aligns the column values at the top, middle or bottom of the table cells.
|
Text
|
Select a text color to display for the column values in the results.
|
Background
|
Select a background color to display for the column in the results.
|
Style
|
Select a font style to display for the column values in the results.
|
Labels
|
Indicates whether to suppress or repeat repeating data for every row in a request. Select Suppress to display repeating data only once and suppress duplicate rows. Select Repeat to display repeating data for every row. Select Default to retain the default label display characteristics.
The data in one column of a table may be repeated in relation to rows of data in other columns in the table. For example, if one column lists customer names and another column lists the states those customers are in, the state data could be repeated for each customer row. You can display duplicate data only once, or to display it for every row. Displaying duplicate data only once can make a table easier to read, and can make distinctions in that data more apparent.
|
Aggregation Rule
|
Select the aggregate rule to apply to this column. The selections reflect any related formula already associated with this column.
|
Use Default Data Format
|
You can control the way your data is displayed by overriding the default display characteristics. The selections that are available are based on the data type in the column.
For example, if a column contains numeric data, the type choices may include Number, Currency ($), or Percentage (%). You can then choose the number of decimal places to display and how to display negative numbers. If a column contains text, you can treat that text as Plain text, HTML, MailTo address, HyperText Link, and Image URL.
Based on your selection, the Custom Text Format box shows the HTML string used to display the data.
|
Treat Text As
|
Select the type of data format to apply to the column values. To access this field, you must clear the Use Default Data Format check box.
|
Custom Text Format
|
To access this field, you must clear the Use Default Data Format check box and select Custom Text Format in the Treat text as drop-down list.
Use this field to type a custom formatting string. You can type HTML calls that provide special formatting. You can also type any valid HTML string, including JavaScript, VBScript, and so on.
For example, typing HTML such as the following allows you to control the column width and height in tables and pivot tables:
[html]<span style="width:200px"
style="height:50px">@</span>
If you do not know HTML, JavaScript, VBScript, and so on, you can consult a third-party reference.
|
Use These Settings
|
By default, column format settings apply only to the current request; however, you can apply settings to other requests by selecting an option in this field. The options that appear are controlled by the privileges assigned to you by your Siebel Administrator.
|
