Group Report Data

Grouping data in a report

Groups can be added to reports to combine like results based on a specified field into a collapsible node on the report. Group fields will be displayed as columns on reports but cannot be re-ordered. Groups take priority over the order in which the fields in the Columns pane are displayed.

If the Display Totals option is enabled for a specific field, the sub-totals for the field within each group will be displayed on the report along with the Grand Total for the report.


Follow the steps below to add Groups to a report.

  1. Select Reports > Builder.

  2. Use the Show All button to view all custom reports. Or use the Search Bar to further drill down your search.

  3. Select the Report from the list.

  4. In the Report Fields pane

    1. Expand the Report Field category to find the field you wish to group the report with. 

    2. Or use the Field Search to search for fields in all categories. 

      You can search and filter by a specific field type (Date, ID, Money, Number, Text) by Clickingand limiting the search to specific report field types.  

  5. Drag and drop the field into the Groups pane.


Group levels

Groups can be added to reports to combine like results based on a specified field into a collapsible node on the report. Group fields will be displayed as columns on reports but cannot be re-ordered. Groups take priority over the order in which the fields in the 

By default, the grouping level of the first field added as a group is set to Level 1, the second is set to Level 2, etc. It is not necessary to add the same field to both the Column pane and Groups pane of the Report Builder.  In fact, doing so will cause it to display as two columns on the report when run.

Follow the steps below to change the grouping level for a field within a report.

  1. Select Reports > Builder.

  2. Use the Show All button to view all custom reports. Or use the Search Bar to further drill down your search. 

  3. Select the Report from the list.

  4. In the Reports Fields pane.

  5. Right click on the field within the Groups pane, select Grouping Level and select the level you wish this field to be set to.

If two fields are set to the same grouping level, the filter window will allow the grouping precedence for the two fields to be specified within the General Filter tab on the filter dialog window. The grouping selection drop down will also contain a blank entry that when selected will apply no grouping to the report.


Check Your Understanding:

When multiple fields are grouped on a report, the grouping level determines which field the report is grouped by first, then which field each sub-group is grouped by.

For example, if a report containing Patient ID (Account Number), Patient Last Name, and Patient First Name was grouped by Patient Provider (Provider ID) (Level 1) and then by Patient Gender (Level 2), it would display as follows:


If the same report were to be grouped by Patient Gender (Level 1) and then by Patient Provider (Level 2), it would display as follows: