Group Report

For Group Reporting, you will take a pre-existing report and edit it from the File tab and down to Reporting at the top left hand side.

Highlight the Report and click on Edit to open the Report Designer. Go to the Group and Sort pane and click on the Add a Group button. In the example below, we select Risk from the available fields.

Then change the sort order using the Move Up button so that the Risk takes precedence.

By grouping by the Risk element a new band called Group Header has been automatically inserted in the Report Layout. The Page Header Band is no longer required (as it doesn’t hold any more elements) so you can right-click on it and delete it.