Editing a Table

You can edit tables from the Design tab or the Source tab.

In the source the tags are labeled:

Table: External border of the table.
Table_TH: Table header background color and cell borders.
Table_CH: Table column background.
Table_TD: Detailed cell style. Table_TD can be nested to display alternating background color for the detail rows.

Editing Table Styles

The look and feel of a table can be edited by choosing an element from the Table Styles tab. To create a style, click the Create a New Style button . The Table Wizard > Layout window opens (“Table Wizard > Layout”). You can select an existing style, which adds it to your palette, or you can create a new style and save it to your palette. If you want the style to have a name, you must add a name in the Layout window, even for the default styles.

Table Styles Tab

To edit a style in the palette, double-click the style. The Table Wizard > Layout window opens, allowing you to edit the style and save it either as a new style or with the same name. To edit table layout in the Design view, right-click the table and choose Change Table Style.

Change Table Style

The Table Wizard > Layout window appears (“Table Wizard > Layout”).

You can also decide which table sections to create. If the dataset for the table contains groups, it can be convenient to select the check boxes Add Group Headers and Add Group Footers, which are by default not selected. This option creates group header and footer sections in addition to the other sections.

To delete a style from the Table Styles tab, right click and choose Delete Style.

Editing Cell Contents

You can edit the content, style, and size of each cell or group of cells in your table. To edit table content, double-click your table. The table opens in a separate tab in Design view.

Table Editing Tab

To edit the content and style of a cell, click the cell. Switch to the Properties tab. On this tab you can edit location, size, color, style, and print details for the cell.

Cell with Open Properties Tab

You can edit the size and position of a cell, as well as copy or delete it, by right-clicking on the cell.

Cell Right-Click Menu

If you want multiple cells to have the same properties, shift-click the cells. Any changes you apply on the Properties tab applies to every selected cell.

You cannot select an entire row with one click. You must shift-click all the cells in the row. You can select an entire column. See Working with Columns for more information about columns.

The following figure is the table created in Creating a Table, after formatting and editing it:

Formatted Table

Editing Table Data

The dataset run for the table can be edited by right-clicking the table and selecting Dataset and Query. The Dataset and Query dialog appears, filled in with the data and query from your current table.

Dataset and Query Dialog

In this dialog, you can set the values of the dataset parameters. The use of parameters allows you to dynamically filter the data used to fill the table. Suppose, for instance, that you have a report that prints a set of orders. If we want to use a table to display the order details, a parameter allows us to specify the order ID to filter the order details in an SQL query.

Unlike charts and crosstabs, a table always requires a subdataset. Tables cannot use the main dataset.