Modifying a table

Once a table has been created, you can further modify it by accessing its shortcut menu wizard which is composed by a set of screens that are similar to the wizard screens used to create the table. For example, you can change the data used by the table, apply some grouping, sorting criteria to the table, and so on.

To modify a table after it has been created:

  1. Right-click the table and select Table Wizard from the shortcut menu to display the Table Wizard.
  2. In the Data screen, specify a new data source for the table if required.
  3. In the Display screen, specify the fields you want to display in the table and how to sort records in the table.
  4. In the Group screen, specify the grouping criteria, and then the sorting direction of each group level in the Sort column.
  5. In the Style screen, select the style you want to apply to the table.
  6. When done, click Finish to accept the changes.

See also the Table Wizard for page report or web report/library component for detailed information about options in the wizard.

Notes:

Aggregating on a detail column

You can summarize the data in a detail column if required. To do this:

  1. Right-click the detail column and select Aggregate On from the shortcut menu. The Aggregate On dialog is displayed. See the dialog.
  2. From the Aggregate Function drop-down list, specify a function to summarize the field in the detail column.
  3. Specify the Group By option.
  4. When done, click OK. Data in the detail column will be summarized based on the group by setting using the specified function.

At the same time,