Report Authors / Report Wizard / Configuring Report Controls / Configuring Table
Configuring Table

General

Table is a data display control that visualizes your data in a structured, multicolumn, multirow format. Below is an example of how a table that displays Taxi Drives data appears in the report output:

Table Sample with Grouping 

The report wizard guides you through the process of configuring a table with a series of intuitive steps, as described below.

Choosing Table Query and Field

Choosing Table Query and Field in the Table Wizard

In the Query drop-down, you can select one of the report's available data queries. For detailed information on setting up queries, see the Configuring Data Queries in Report Wizard and Configuring Data Set Properties documentation pages.

The Fields list displays all the fields retrieved by the selected query. To display all these fields in the table, click the (select all) checkbox. Alternatively, you can select only a subset of fields that should be displayed in the table, as shown in the screenshot above. Click Next > to proceed to the next step.

Configuring Table Groupings 

Configure Table Groupings in the Table Wizard

The Configure Table Groupings step allows you to organize your data into groups, making it easier to analyze and display. Groupings are especially useful when you want to categorize your data by specific fields, such as taxi drive category, as shown in the screenshot.

General Settings

In the Layout section, you can choose how the groups are organized:

Group Settings

This section provides settings for configuring the groupings.

Once you have configured your group settings, click Next > to proceed to the next step.

Configuring Table Columns 

Configure Table Columns in Table Wizard

The Configure Table Columns configuration step allows you to customize the columns that will be displayed in your table. The list on the left side shows the fields that were selected on the initial Choose Table Query and Fields screen. However, fields that were selected for groupings in the previous step will be excluded from this list.

Each field in this list will be represented as a column in the table. You can modify various properties for each column, as explained below.

Rearranging Columns

You can change the order in which the columns appear in the table by selecting a field and using the Up (↑) and Down (↓) buttons on the right side of the list. This allows you to rearrange the order of columns according to your reporting needs.

Modifying Column Properties

When a field is selected, its properties can be adjusted in the section on the right.

Summary values will be displayed in the group footer(s), if they were configured, and also in the table footer.

Once you've made the necessary modifications, click Next > to proceed to the next configuration step.

Configuring Table Colors

Configure Table Colors in Table Wizard

In the final step of the Table Wizard, you can apply a color theme and style to your table to make it visually appealing and ensure consistency in the design. The preview pane on the right allows you to see how your table will look with the selected theme and style before finalizing the configuration.

Theme

The Theme dropdown allows you to select from a variety of pre-defined themes that determine the base color palette for the table. For instance, the screenshot shows the Active theme selected, which applies a specific set of colors to different table elements, such as headers, footers, and data rows.

Style

The Style dropdown provides additional customization within the selected theme by offering various styles to apply. These styles can subtly change how colors are used in the table. In the screenshot, the Light Style 1 Accent 1 is selected, which applies different shades of blue to the headers and footers, giving the table a clean and professional appearance.

Preview

On the right side, the Preview section shows how your selections will look when applied to the table. The preview displays how different table elements—like the header, group headers, group footers, details, and the table footer—will be styled. Each group header and footer is visually distinct, using alternating colors to improve readability.

Once you’ve chosen the desired theme and style, click Finish >> to apply the settings and generate the table in your report. 

See Also