Organize report data

The information displayed in a report comes directly from the fields of the layer or table on which the report is based. One way you can customize a report is by organizing its data. When information can be divided into groups it can help highlight trends that may otherwise go unnoticed. For example you may want to have certain employee records grouped by the department they belong to and sorted ascendingly based on their hire date.

Reports support the following three methods of organization:

  • Grouping—Gather report records by a common value.
  • Sorting—Organize report records in alphabetical or numerical order based on the values in one or more fields. Sorting can be performed in either ascending or descending order. Optional case sensitivity can also be utilized.
  • Summary statistics—Show the complete set of information for the reported records. Examples include an average or maximum numeric field value as well as the total count of a string value in a field.

Using a combination of the organizational methods available, a report can be created that provides both organized details as well as summary information for quick reference. Grouping and sorting can also be added to an existing report as well as updated after the initial report creation.

Organize data in the Create New Report pane

Grouping and Sorting are optional levels of organization that can be applied to your report data. However, this can be defined during report creation. To organize data in the Create New Report pane, complete the following steps:

  1. On the Insert tab, in the Project group, click New Report New Report to open the Create New Report pane.

    Alternatively, right-click a layer in the Contents pane and click New Report New Report to open the pane and have the report's data source set directly.

  2. In the Create New Report pane, review or update the Report Name and Data Source options and click Next.
  3. In the Filter the data options, specify the fields and rows to show in your report and click Next.
  4. In the Organize the data options, select the fields by which you want the data to be grouped by and set a corresponding sorting direction.

    Sorting direction includes Ascending and Descending order, with the additional option to use a case sensitive sort order. Multiple groups are sorted in a top-down manner.

  5. Specify any additional data sorting desired. This sorting will be apparent within each group. Only fields that are not being used as groups can be selected as multiple sorting levels are applied in a top-down manner after the sorting required by grouped fields.
  6. Optionally define any summary statistics to be included.
  7. Click Next to continue to the Design the report options, or click Finish to generate the report using the current configuration.

Add grouping into a report from the ribbon

Additional grouping can be added to a report at any time using the following steps:

  1. On the Insert tab, in the Data group, click the Group button Grouping to open the Insert Group dialog box.
  2. Choose the field you want to group by and the corresponding sorting direction.
  3. Click OK.

A new group header and footer will be added to the report.

Change data organization in the report properties

Sorting and grouping can be changed after it has been established using the following steps:

  1. In the Contents pane, right-click on the report title and click Properties.
  2. Click the Grouping and Sorting tab.
  3. Select the fields you want the data to be grouped by and a corresponding sorting direction.
  4. Specify any additional data sorting desired.

    Alternatively, click the Clear button to remove all grouping and sorting.

  5. Click OK to apply this change.

Related topics