Filter report data

A report is built from a data source that you define during the initial creation process in the Create New Report pane. By default, all rows and fields are included in a report. Rows can be filtered by constructing an SQL query. Fields can be checked or unchecked and arranged to your preferred order.

If a field alias exists for a field, it is automatically used as the column header when creating the report.

Filter data in the Create New Report pane

To use the Create New Report pane to filter data, 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. Expand the Rows menu to set data filtering. You can choose from the following:
    • All rows—All data is used in the report.
    • Filter by expression—Only data defined by a custom query is used in the report.
  4. Specify the fields to be included in the report by unchecking any fields you do not want to use. Click and drag to reorder the selected fields.
  5. Click Next to continue to the Organize the data options, or click Finish to generate the report view using the current configuration.

Add fields to a report after creation

Additional fields can be added to the Group Header or Details section of a report open in the report view by completing the following steps:

Note:

Fields added into the Group Header section only report their first encountered value.

  1. Click the section of the report you want to add a field, using either the Contents pane or the report view to activate it.
  2. On the Insert tab, in the Data group, click the Field button Fields.

    The Insert Field Value window appears.

  3. Choose the field to be added. If a numeric field is chosen, numeric formatting may also be selected.
  4. Click OK and draw a box where the field should appear.

The specified field is added as a dynamic element to the report at the designated location.

Related topics