Modifying a summary table
Using Report Studio, you can work with summary tables to format data, organize data in groups, sort data, create filters, and insert charts as you would for a detail table. This section describes the actions you can perform on dimension columns, attribute columns, measure columns, and each column header. Table 3‑1 lists the actions you can perform on dimension columns, measure columns, attribute columns, column headers, and the entire report table.
Table 3‑1 Modifying data in a summary table
Action
Dimension
column
Attribute
column
Measure
column
Column
header
Report
table
Advanced filtering
 
 
 
 
Advanced sorting
 
 
Creating a new computed column
 
 
 
 
Creating aggregate data
 
 
 
 
Creating borders
 
 
 
Creating data set filters
 
 
 
 
Creating filters
 
Creating groups
 
 
 
 
Creating hyperlinks
 
 
Creating page breaks before or after a group
 
 
 
 
Creating sections
 
 
 
 
 
Deleting a group
 
 
 
 
Deleting the column
 
 
Disabling default hyperlinks
 
 
 
 
Editing the column header text
 
 
 
 
Filtering top/bottom N
 
 
 
 
Formatting data
 
 
Grouping date‑and‑time data in intervals
 
 
 
 
Hiding a column
 
 
 
 
 
Hiding details for a group
 
 
 
 
Inserting a chart
 
 
 
Reordering columns
 
 
Sorting column data
 
Specifying alignment properties
Specifying column width
 
 
Specifying conditional formatting rules
 
 
 
 
Specifying font properties
When creating filter conditions for a summary table that uses a data model in a BIRT data object as the data source, the following conditions apply:
*You cannot use Advanced Filter to filter data in a measure column.
*You cannot use Advanced Filter to filter data in dimension and attribute columns if the summary table already contains a measure column with a defined filter condition.
*You can use Advanced Filter to create filters for dimension and attribute columns in a summary table using a data model data source, if no filter condition is defined on a measure column.
Modifying the report table
You can perform the following actions at the report table level in a summary table:
*Insert a chart at the report table level.
*Hide a table, and display the corresponding chart.
*Sort data.
*Specify font properties.
*Specify alignment properties for column data.
*Format data types.
*Add a border for the table.
*Add data fields from the data set.
*Reorder columns.
*Create a bookmark to the summary table.
To add a table border, add data fields, insert a chart, reorder columns, or create a bookmark to the summary table, choose an option from the context menu of the report table, as shown in Figure 3‑7.
Figure 3‑7 Modifying the report table using the context menu
Modifying labels
You can perform the following actions on a column header or an aggregate label in a summary table:
*Edit the header or label text.
*Modify the alignment of label text.
*Format font properties.
*Create a border for the label.
To modify a column header or an aggregation label, select the column header and choose an option from the context menu. The context menu appears, as shown in Figure 3‑8.
Figure 3‑8 Modifying a column header using the context menu