Displaying Data in Tables

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Present data in tables

Tables

The simplest style for displaying data is tables.

Web Intelligence provides the following types of tables:

Table Format

With Web Intelligence, you can switch from one table format to another table format that is more appropriate for the information displayed in the report.

Data Additions to a Table

When you want to add a new object to a table that is not in the query, you need to edit your query, add the data object in the Query panel to the Results Object panel and run the query before you can add the object to an existing table.

See the following video to learn more about the steps to add an object to an existing table.

Copies of Tables

You can use one of the copy and paste methods to copy a table and paste it as another block in the report.

This technique is useful to show the same data in another format, for example, as a chart with formatting to highlight certain information.

Table Deletion

You can delete tables, rows, or columns by using a shortcut menu.

Table Header Freezing

You can freeze headers, rows or columns in tables to keep them displayed as you scroll through data.

The zones you can freeze depend on the table type. The following table lists zones you can freeze according to the type of table:

Vertical tableHeader rows and columns
Horizontal tableHeader rows and columns
Cross tableHeader rows and header columns

Log in to track your progress & complete quizzes