Creating dynamic reports in Table ViewYou can use Table View in Browse mode to group your data by a field, display subtotals for a field, create subtotals for each group of data, or display a grand total for a group of data.
1. In Browse mode, right-click the column heading for the field that you want to use for grouping the data, then choose Add Leading Group by <field name> or Add Trailing Group by <field name>.
2.
3. If you want to display the name of each group in the summary row, right-click the left margin of the summary row, then choose Add Group Field (<field name>).
• In Browse mode, right-click the column heading for the field that you used for grouping the data, then choose Remove Leading Group by <field name> or Remove Trailing Group by <field name>.
1.
2.
3.
• You need to have Full Access privilege set to create summary fields in Table View. If you don’t have Full Access privilege set, only existing summary fields are available in the shortcut menu.
1. In Browse mode, right-click the column heading of the field that displays subtotals and choose Leading Subtotals or Trailing Subtotals.
2. Deselect any options that you want to remove from the Leading Subtotals or Trailing Subtotals shortcut menu.Note Removing subtotals from Table View does not remove the subtotal summary fields from the database. To remove the summary fields from the database, choose File menu > Manage > Database, click Fields, then choose the summary fields to remove and click Delete.
3.
4. In Browse mode, right-click the column heading of the field that displays grand totals and choose Remove Leading Grand Summary by <field name> or Remove Trailing Grand Summary by <field name>.