From the Layout Properties window you can set all the formatting options that are available for the query results. The options are divided into the following groups:
You can apply formatting options to entire columns, individual cells, column headings, and summary cells. The Layout Properties window includes a tree that will help you to navigate the query results, and select the cells or columns for formatting.
Field | Description |
---|---|
Heading | Displays the name of the column that you have selected for formatting. You can type a new heading for the column in this field. The new name will appear in the query results. |
Grouping and Aggregation | Displays the aggregation specifications that will be applied to the column. If none have been specified, this field is not available. |
Width (in pixels) | Specifies the width of the column in pixels. You can change the width by typing a new number in the text box or selecting a number from the drop-down list. |
Source | Displays the source for the data that is in the column that you have selected. If the column contents is the result of an expression, the conditional expression that was used is displayed. |
The available Format options vary depending on whether you selected a column with character, numeric, date or time data.
You can specify conditional formatting options for each detail, summary and grand total cell in a column. Based on an expression, each cell in the column can be formatted differently. For example, within a column, you could specify that if a cell's contents equals 0, then display the cell with a red background and if value is 100, display the cell with a blue background.
To set conditional formatting follow these steps: