Report Groups

Report Group Wizard

The easiest way to insert Report groups is to use the Group Wizard.

Click Insert Group on the Insert menu.

Select the field to group on and optionally select fields to add a group footer total.

Note: DBxtra will only show numeric fields to add totals.

Click Insert Group.

You can now add any formatting to the controls in the group header and footer band.

You could also add additional fields to the group header and footer. Of course those should be fields related to the group and not detail fields which belong in the detail band.

Insert Groups manually

To insert a group manually right click in the Report design area and select Insert Band &endash; GroupHeader.

If you choose to add groups manually then you need to repeat this process for each Report group header and footer.

Manually inserting groups does not offer you the option to add group totals.

You can insert or edit group totals manually by adding a label and defining the labels Summary properties.

Reorder Groups

Option 1

Right click the group band.

Select either Move Up or Move Down.

Option 2

Select the Report group and click the small arrow above it.

Click on Edit and Reorder Bands.

Use the buttons to reorder group bands.

You can also use this dialog to format group bands.

Keep Groups together / repeat on Every Page

Select the Report group and click the small arrow above it.

Click on the option Keep Together and / or Repeat Every Page.

The option Repeat Every Page will display the group header on each Report page.

Delete a Report group

Select the Report group and click the small arrow above it and select Delete.

Movies

Watch Movies

The Visual Report Designer

Design a Report

Report Bands and Sections

Calculated Fields