Creating dynamic reports in Table View
You 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.
Note  You can view the quick report only in Table View. The changes you make have no impact on the current layout.
To group data by a field:
1.
For example, if you want to display the sales data by City and add a summary row at the end of the records for each city, choose Add Trailing Group by City. If you want to add the summary row before the records for each city, choose Add Leading Group by City.
Adding a leading/trailing group automatically sorts the records by the field that you used for grouping the data. For example, the cities will be listed in alphabetical order.
2.
3.
Tip  You can add leading/trailing groups for multiple fields to display different categories for each group of records.
To remove a group:
 •
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>.
To display subtotals:
1.
2.
Choose Leading Subtotals or Trailing Subtotals, then choose options from the shortcut menu.
 
A new row in the beginning of the table (for leading) or at the end of the table (for trailing) displays the subtotal for the field.
If you have also added leading or trailing groups to the table, the group summary rows also display the subtotal for each group for the specified field. You have to choose a leading subtotal to display subtotals for leading groups and a trailing subtotal to display subtotals for trailing groups.
3.
Notes
 •
 •
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.
To remove subtotals from Table View:
1.
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.
To display grand totals:
1.
2.
3.
Choose Add Leading Grand Summary or Add Trailing Grand Summary.
A new row in the beginning of the table (for leading) or at the end of the table (for trailing) displays the grand total for the field.
4.
To remove grand totals from Table View:
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>.