Results and Tables

Subtopics

Adding a Table
Working with Columns and Rows
Sorting Results/Table Items
Number Formatting
Applying a Results and Table Filter
Results and Table Totals
Adding Computed Items in Results and Tables
Paging Through Results Data

When you refresh a query or import data, the Interactive Reporting retrieves data to your browser and displays it in the Results section. Although the query may have accessed several different database tables, the results set is displayed as a single table. Each requested item is displayed as a column in the table and each database record is a row.

Use the Results section to:

Verify that your query returned the correct information.
Refine and extend the data set by applying filter conditions or create new computed or grouped items.
Sort or use text and column formatting features to enhance the appearance of data results.
Add summary totals or subtotals and compute them with data functions.
Print or export the retrieved data to other applications.

All reports, including tables, pivots, charts, are based on the data that is retrieved to the Results section.