Related Topics:

Reports

Charts

Report Builder

Use the Report Builder to design the reports and charts that will be available in the Reports page and the Charts page. You can save reports that are visible only to you or shared with a specific user or group. If you have the required permissions, you can also modify the built-in "Standard" reports or save new "Public" reports that are visible to all users in the entity.

To access the page, choose Options > Designers > Report Builder.

Use the Select Report drop-down lists to select a report/chart to create or modify. For example:

To preview the results, save the report and then choose Options > Report > Generate.

Reloading Defaults and Deleting Saved Reports

For predefined report types (Standard Reports, Chart Reports, Administrator Reports), you can click to reload the last saved settings. If the saved settings differ from the default for that type of report, you can also click to restore the application defaults.

What's changed? Starting in Version 2019, the default Standard and Chart Reports can be modified by users with the "Report Builder - Set Application Default" permission.

For reports that were created by users (My Reports, My Chart Reports, Public Reports, Public Chart Reports, Custom SQL Statements), you can click to reload the last saved settings or to delete the report.

Filter Criteria and Fields to Display

The table contains a row for each field that will be displayed in the results and/or used as a filter.

Note: The maximum number of columns that a report can include is determined by an application admin.

Part Details and Serialized Details

When applicable, report results can include information about the particular template part or serialized system that each incident or problem pertains to:

In the Report Builder's Additional Fields list, these fields are identified with the prefix "Part Detail" (for template parts) or "Serialized Detail" (for serialized systems).

Print Preview Links

A Print Preview field is a link to a customized presentation of the data for a particular record. If an administrator has configured this type of field in the page for a given record type, you can include those links in your report. The report results will show the same link that is displayed in the record. Since every record will have the same link, the criterion columns will not be available for this type of field.

Filter Criteria Groups

If you have specified more than one Filter Group in the table, you can toggle between AND () and OR () to specify the operator that will be applied between groups.

In the following example, the results will include records that match all of the criteria in the first group (AND operators for all fields in Group 1) or the single criterion in the second group (OR operator between Groups 1 and 2).

Sorting

When you are building a report, this area specifies how the results will be sorted when they are generated. The results will be sorted by each field in the Selected list, successively.

Select a field and click or to move it from one list to the other. Double-click a field in the Selected list to toggle between ascending (ASC) and descending (DESC) order.

Users can also change the sort order after the report is generated. (See Reports.)

Output

When you are building a report, this area determines whether the results will be displayed in HTML or XSLT.

Chart Control and Chart Appearance

When you are building a chart, these areas specify how the data will be presented.

Tip: The Y-Axis list  excludes some types of fields  that are not relevant for this type of chart (e.g., descriptions, check boxes, accessories, companies, trees, part details, etc.).

In addition, it is not recommended to select fields that show counts obtained from the query (e.g., Action Count, Status Count, Chargeable Incident Count, etc.). In such cases, the chart will show a separate bar or slice for each record and increment any duplicate counts (e.g., 2, 2 [1], 2[2], etc.).

The appearance settings specified here will be applied when the chart is first generated. Users can also change these options after the chart is generated. (See Charts.)

In the following example, these settings will generate a horizontal bar chart that shows the 20 dates on which the greatest number of incidents were created along with a line showing the average number of incidents created daily.

Save Report Window

When applicable, you can use the Save Report window to enter or change the Report Name, Report Description and Report Icon.

Depending on your permissions, you may also be able to select:

Tip: If you create a report for another user, or for a security group that you don't belong to, you will not be able to access it again after the save. If you need to be able to edit the report again in the future, it is recommended to make sure you belong to the security group or save your own personal copy that you can modify and share again if needed.

 

© 1992–2019. HBM Prenscia Inc. ALL RIGHTS RESERVED.

E-mail Link