Report Administration module
Learn how to administer reports on the ServiceNow platform using the module.
Use the record list view to filter, view, or modify reports using any of the standard record list controls. Click New to create reports or select any of the records to display the report as a form. All the standard ServiceNow form controls apply.
You can select the table and field on which to report and the characteristics of the report format. Create a condition in the Filter field to further restrict the data that is presented in the report and select a role that can use the report.
Report Security
The Report Security enforce access control checks plugin allows administrators to use access control list (ACL) rules to restrict report access. This functionality prevents unauthorized users from editing, updating, or deleting reports either through the UI or through a URL construct. See Access control list rules for more information.
Available Report Fields
| Field | Input Value |
|---|---|
| Title | A unique and descriptive name for the report. |
| Table | The ServiceNow table against which this report is run. |
| Field Name | The name of the group-by field. |
| Type | The report type for this report. |
| Chart Size | Large, medium, or small. |
| Visible to | Select a group whose members are authorized to see the report. Select Everyone to give all your users access. |
| User | The user who can view the chart. Enter GLOBAL to make the report accessible to all. |
| Filter | The filter applied to the report data. |
| Roles | The roles required to view the report. |
| If added to the form, the following fields are available | |
| Aggregate | Determine how you want the data in the report aggregated. The default is
Count, which displays the number of records selected.
When you select Average, Sum or
Count Distinct, you can select from a list of additional
fields whose values you want to use to aggregate the data. Typical values to use
as an average or a sum are the time measurements, such as Business
duration (expressed in days, hours, and minutes) and
Resolve time (expressed in seconds). Other fields, such
as Priority, have numerical values associated with their
levels and can be used as aggregators. Note: Averages are calculated by dividing
the sum of all fields by the number of those fields that contain a value. Fields
that are empty or that contain a light gray zero are not included in the field
count that is used when dividing the sum. |
| Content | An HTML field for describing the content of the report. Not processed in the generation of the report. |
| Display grid | Select to display a table under the chart that contains a breakdown of the requested data. The aggregation units are Count, Average, Sum, or Count Distinct. The percentage of the total data represented by each discrete piece is displayed. |
| Group | Select a group whose members are authorized to see the report. select Everyone to give all your users access. |
| Interval | For Trend or Trendbox charts, the interval of time to measure along. |
| No Groups | Use the values in this list to limit the number of bars that appear in the chart. The platform displays 12 bars by default, from high values to low values and puts the remaining data into an Other category. You can select to display 10, 12, 15, 20, or all bars. |
| Others | Check box to include the Other group in the report. |
| Select fields for list | The fields that display in a list report. |
| Select fields for orderBy | The order of fields that display in the report. |
| Show Empty | Whether to display empty categories. |
| Sumfield | The field to perform a sum on for Trend or Trendbox Charts. |
| Trend Field | The field to track over time for Trend or Trendbox Charts. |