Tables

A table is the simplest report type. It can be used to display all the data in the report or to summarize the data across one set of related fields. Tables are broken down into Columns and Rows.

Columns: can include both properties and measures
Rows: Each row represents an object being measured. Rows can be grouped by their properties to display data more effectively.

Sorting a Table

Click Table Icon. The Sorting window appears. If the table is already sorted, the window shows the fields that are used.
Click Add Fields to add a field. The Fields window appears with a list of available fields. It only lists fields that are not already used.
Select one or more fields to sort by, and click OK. Use the Ctrl key to select multiple fields.
Arrange the sorting precedence of the fields
1. Select each field in the Sorting window and use the sorting icons.
To remove a field, select it and click the "X" icon.
Click OK.

The table updates to display the rows sorted by your selected fields.

Ad Hoc Editor’s Table Layout

Component	Description
Columns area	Drag fields and measures from the Data Selection panel to this area to create columns.
Groups area	Drag fields from the Data Selection panel to this area to create groups. You can't add measures as Groups.
Canvas Options	Click to select Detailed Data (default), Totals Data, or Details and Totals.
Column labels	Displays the label for each column above the table in a header row. Highlight a column and right-click to change or remove the label. When you remove a column label, its database name is shown in the editor, but the label does not appear in reports created from the view.
Group header	Displays the label of the group and its current value. Groups and sub-groups can be nested, and their first occurrence headers are all found at the top of the view. Right-click the first occurrence of a group to access group options like removing the group from the table, changing the label, or creating a filter on that field. You can reorder the first headers to change the group nesting order.
Group summary	If Totals Data or Details and Totals is selected, shows the group value and group total, if any. To select a different summary function, modify the column summary.
Column Summary	Gives a total value for all the rows in the column. To see all summaries, select Totals Data or Details and Totals from the Canvas Options menu. To add or remove a summary, right-click the column and select Add Summary or Remove Summary. To select a different summary function, right-click the column and select Change Function.
Column of Values	A vertical region in the canvas showing data from a single field. Right click a column to access column options like sorting on that column, adding or removing a column summary, changing the column’s data format or label, and creating a custom field or filter based on the column’s field.

Common tasks when working with Ad Hoc tables include:

Action	Description
Resize a column	Click the right border of the column header and drag it horizontally. For more precision, click the column to highlight its borders before dragging them. The minimum width of a column is determined by its longest visible member (either a row or the label itself). When the data doesn’t fit the column width, it wraps (in Excel and HTML formats) or is truncated (in PDF format). By default, the canvas displays only the first 15 rows of data. To verify that the column widths are sufficient, click Full Data to display the full set of data.
Add blank columns	To add white space between columns, drag the Spacer from the list of available measures and drop it in the Columns area. Drag the spacer’s edges to adjust its width. You can add any number of spacers to a view. To create space between the leftmost column and the group labels in a table, drag a spacer to the leftmost position. The margin provides a buffer between the first column and the groups summaries.
Sort a column	Click or right click a column in the Canvas and select Use for Sorting. You can add fields and change the sort from ascending to descending. You can sort by multiple fields including those not displayed in the view.
Filter a column	Right-click a field or a column in the layout band or the Canvas and select Create Filter to filter your results by the values in that field. To select a filter operation other than the default, click the filter’s icon and select Toggle Operation.
Show all groups	When a table is grouped by multiple fields, you may see only a few groups or even a partial group. Click Full Data to view the full dataset; click Sample Data to return to the subset.