You can edit tables on 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
You can edit the look and feel of a table by choosing elements from the Table Styles tab. To create a style, click the new style button . In the Table Wizard Layout window, you can select a style to add to your palette or create a new style to save to your palette.
Table Styles Tab |
To edit a style in the palette, double-click the style and edit it in the Layout window. You can 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 |
You can also decide which table sections to create. If the dataset for the table contains groups, it can be convenient to select the Add Group Headers and Add Group Footers check boxes.
To delete a style right click it in the Table Styles tab 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 where 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, or copy or delete it, by right-clicking on the cell.
Cell Right-Click Menu |
Use shift-click to select an all cells in a row. See Working with Columns for information about columns.
The following figure is the table created in Creating a Table, after formatting and editing:
Formatted Table |
Editing Table Data
You can edit the dataset used for the table by right-clicking the table and selecting Dataset and Query to display the Dataset and Query Dialog.
Dataset and Query Dialog |
Here you can set the dataset parameters to dynamically filter the data used in the table.
Suppose, for instance, you have a report that displays order details in a table, you can use a parameter in your SQL query to specify the order ID to filter the order details.
Unlike charts and crosstabs, a table always requires a subdataset. Tables cannot use the main dataset. |
Recommended Comments
There are no comments to display.