Reports

Last modified on 2022/06/24 16:35

Definition

A report is used to extract data associated with a menu in real time in order to generate a custom statistical report (in PDF or CSV format, etc.) that is more complex than the reports built using standard filters.

It can also be used as an archive tool or to establish a history of statistical data by storing snapshots of data managed at a given time.

EndDefinition
  • A report is built around a parent query that accesses a set of standardized data from the database.
  • The data is extracted using filters. Views are used to group and format data. Contextual links enable you to open the form specific to each record in the report.
  • You can run reports:
    • Immediately, via the associated menu.
    • At a scheduled time based on a frequency defined for the scheduled report. The statistical report will automatically be sent by email to a list of recipients.
  • Reports can be stored in folders that are organized by function.

Example

The Service Desk Activity report is defined for the Service Operation menu.

  • It uses the Action Operation parent query.
  • Two filters are defined: Service Desk Calls and Incidents Not Solved.
  • Three views are used to present data.

==> Display the report via the Service Operation menu

  • The two filters and the three views are available in the drop-down lists and can generate several statistical reports if required.
  • A contextual link for each record enables you to open the form specific to the incident.
             Example - Execution mode - List of filters and views.png

==> You can create scheduled reports if you want to send monthly activity reports to managers in the IT Department.

Notes

  • A dedicated Reports menu item is available in each menu. Your user profile must be authorized to access it.
    • It groups all reports associated with the menu.
    • It enables you to run reports immediately.
  • You can create or modify reports as long as you have the appropriate rights to the Administration > Reports > Reports menu.
    • You can create them by selecting Administration > Reports > Reports in the menu.
    • You can modify them:
      • By selecting Administration > Reports > Reports in the menu.
      • By selecting the Reports menu item in the associated menu.
  • Parent query of reports:
    • You can only create it without any specific user rights when creating a report.
      • The new parent query will be available for all Service Manager internal reporting tools, e.g. trends, alerts, reports, and purge processing.
      • It will not be available for parent queries used to define standard Service Manager objects, e.g. forms, lists of values, filters, quick filters, views.
    • You can modify it as long as you are authorized to edit display presentations. Open url.png See User Profiles > Edit rights and display rights.
      • Manually added fields will be available for all reporting tools and purge processing.
      • They will not be available in parent queries used to define standard Service Manager objects.
  • The filters and views used in a report are specific to the report. Users can create or modify them without any specific user rights.

Caution

  • Values in catalogs that are inherited from a parent category, e.g. workflow or SLA, will appear in the interface in child categories. However, they will be only stored in parent categories in the database. There will be no values in the child categories.
    As such, reports will only display the values of child categories if these were specifically defined in the catalogs. If this is not the case, there will be no value.

How to solve this issue in reports

  • You can define the values in the catalogs when you create a child category. This will overwrite the inheritance mechanism and store the value specific to the child category in the database. 
  • You can also extract the catalog and specify values for the required child categories. You should then import the updated catalog using an integration model.

Best Practice

  • Duplicate a filter or a view when you need to modify only a few criteria. Next, modify the properties that differ from the model.
  • If you want to add fields to the report's parent query, you should do it before editing the report. Open url.png See How to modify a parent query.

Characteristics specific to versions 2016 and earlier

The Report form in versions 2016 and earlier is different.

  • To modify parent queries, your user profile must be authorized to edit display presentations. This is assigned in the module associated with the menu item using the parent query. Open url.png See User Profiles.

Menu access

  • Administration > Reports > Reports
  • A dedicated Reports menu item is available in each menu.

Screens description

        Reporting.png

Name: Name of the report. 

Comment: Comment field for describing the report. 

Theme: Name of the menu associated with the report. 

  • The report will be available in the Reports menu item of this menu.

Folder Name: Name of the report folder where the report is saved. 

Parent Query: Name of the parent query used to define the report.

  • Only parent queries defined for the Theme will be available.
  • You can click Add icon.png to add a query only when creating a new report. Note: The icon is visible only if you do not select the parent query.
  • You can click Duplicate icon.png to duplicate an existing query only when the report is opened by selecting Administration > Reportings > Reportings in the menu. Note: The icon is visible only if you select the parent query.
  • The fields available in an existing parent query are parent query fields and other fields manually added to Service Manager internal reporting tools and purge processing.

Form: Name of the form to be opened when users click one of the records in the report. A link specific to the record will automatically be added to the first column in the report.

  • Only forms linked to the parent query will be available.
  • Mode for opening the form:
    • Integrated: The record will be displayed in Form mode. Users can modify it based on their rights.
    • Pop-up: Information specific to the record will appear in a secondary window. It cannot be modified.

Visibility: Used to define access to the report by profile. Click Visibility.

  • Visible pane: Profiles with access to the report.
  • Invisible pane: Profiles with no access to the report.
  • Use the Last icon.png, Next icon.png, Previous icon.png and First icon.png icons to move profiles from one pane to the other.

Filter Management: List of filters associated with the report.

  • Default: When several filters are defined for the report, the default filter is the one automatically applied in the Filter drop-down list in the Reports screen. 
  • Add or select a filter. Next, click Display popup icon.png to open the visual filter editor.
    • All fields in the report's parent query as well as other manually added fields will be available for the filter.
               Filter - Reporting

Manage Views List of views associated with the report.

  • Default: When several views are defined for the report, the default view is the one automatically displayed in the View drop-down list in the Reports screen. 
  • Add or select a view. Next, click Display popup icon.png to configure it.
             View - Reporting
    • All fields in the report's parent query as well as other manually added fields will be available for the view.

Procedures

How to create a report

Step 1: Create the new report.

1. Select Administration > Reports > Reports in the menu.

2. Click + New.

Step 2: Specify the main information in the report.

1. Specify the main information in the report.

2. Select the parent query.

  • You can duplicate an existing query via Duplicate icon.png.
  • You can add fields to a parent query.
    • Select the parent query associated with the new report.
    • Click Edit icon.png next to the field.
      The list of fields from the parent query associated with the report and other fields manually added to Service Manager internal reporting tools and purge processing will appear.
    • Add the fields you want. Open url.png See How to modify a parent query.

3. Click Visibility and specify the profiles authorized to access the new report.
 

Step 3: Define the filters to be used in the report.

1. Click Add icon.png to add a filter and enter its name.

2. Define the conditions of the new filter.

  • Click Display popup icon.png.
    • The visual filter editor will appear.
    • All fields in the report's parent query as well as other manually added fields will be available.
  • Click OK.
    You will return to the form of the new report.

3. Repeat the procedure to add the other filters to be used in the report.

Best Practice icon.png  Click Duplicate icon.png to duplicate a filter when only a few criteria change.

  • The new filter will appear at the bottom of the list. It will have the same name followed by the word, (Copy).
  • Click Display popup icon.png then modify the properties that differ from the model.

4. (Note: Only if several filters are defined) Select the Default box for the filter to be applied automatically when the report is opened via the dedicated Reports menu item.


Step 4: Define the views to be used in the report.

1. Click Add icon.png to add a view and enter its name.

2. Click Display popup icon.png.
The view editor will appear.

CreateViewAlertReporting_Procedure

2. Define the order of the columns in the view.

  • Select the Order box next to the field to be moved.
  • Click Insert Here next to the field above which you want to move the selected field.
             View - Alert and Reporting - Insert here link.png

3. Specify the options depending on the type of field.

  • Only for date fields: Select the way you want to group records from the Group by drop-down list.

    example  You want a quick view of all equipment whose warranty expires in 2021:

    • End of Warranty field = 9/1/2021
    • Grouping By Year = 2021
  • Only for tree fields that are not in the last level: Indicate the first and last level of the hierarchy to be displayed.
    • The value 0 is used to display all grouping levels in the hierarchy.

      example  Display the tree field, Location = North America/USA/New York/Manhattan/Broadway

      • Start = 0, End = 0 ==> North America/USA/New York/Manhattan/Broadway
      • Start = 1, End = 3 ==> USA/New York/Manhattan
      • Start = 4, End = 5 ==> Manhattan/Broadway
      • Location (last level) = Broadway
  • Select the measure type you want, i.e. number of records, totals, average.

4. Select the grouping level of the view using the Breakpoint column.

All fields up to this level are marked as Visible.

5. Select the fields you want to display in the view.

6. Click OK.
You will return to the form of the new report.

7. Repeat the procedure to add the other views to be used in the report.

Best Practice icon.png  Click Duplicate icon.png to duplicate a view when only a few criteria change.

  • The new view will appear at the bottom of the list. It will have the same name followed by the word, (Copy).
  • Click Display popup icon.png then modify the properties that differ from the model.

8. (Note: Only if several views are defined) Select the Default box for the view to be applied automatically when the report is opened via the dedicated Reports menu item.
 

Step 5: Save and test the report.

1. Click Save.

  • The new report will be available in the Reports menu item in the associated menu.
  • If you created a new parent query, it will be available for all Service Manager internal reporting tools, e.g. trends, alerts, reports.
  • If you added fields to a parent query, they will be available for all Service Manager internal reporting tools and purge processing.

2. Select the Reports menu item associated with the report.

3. Check that the filter automatically applied when the screen appears is the default filter you just defined.

4. Check that the report results are correctly displayed.

How to create a report using a template

Step 1: Select the template report.

1. Display the list of reports.

2. Click Edit icon.png next to the template.
The Properties window of the report will appear.

Step 2: Create the new report.

1. Modify the information as required in the template report.

2. Click Save as to avoid overwriting the template report. Give a name to the new report.

Tags:
Powered by XWiki © EasyVista 2022