Working with Tables
The table view consists of columns, rows, and groups.
-
Columns in a table correspond to the columns in the data source. They are included by adding fields or measures to the table in the reports view.
-
Rows correspond to rows in the database. The information in each row reflects the columns included in the table.
-
Using groups, rows can be grouped by identical values, in any field with intermediate summaries for each grouped value. For example, a table view of product orders might contain columns to show the dates and amounts of each order, and its rows might be grouped by city and product.
While working within a table, the following menu selections are available:
| Icon | Description |
|
| Toggles between design and display modes. |
| | Provides the ability to save a report in three separate formats:
|
|
| Allows you to export your report in the following formats:
|
|
| Allows you to undo the last change |
|
| Allows you to reset the report to its last saved state. |
|
| Allows you to switch the groups |
|
| Allows you to set the sort order |
|
| Allows you to change the input values |
|
| Allows you to set the properties for your individual report view:
|
|
| Allows you to view a SQL query |
Related Topics