Configuring DMS Advanced Reports

Prerequisites

Configure a Report Rule

A report rule creates an association between a target object (for example, a SiPass server) and a particular type of report (for example, Door Access Summary). Once such a rule is created, selecting the target object allows the associated report to be executed in the Application Viewer tab.

  • System Manager is in Engineering mode.
  • System Browser is in Management View.
  • The default view is set to Show Description.
  1. In System Browser, select Project > System Settings > Application Link Rules.
  1. Select the Rule Editor tab.
  1. In System Browser, select the Manual navigation check box.
  1. In the Trigger Conditions expander, drag one or more report-target objects from any view in System Browser onto the Path area.
    NOTE: You can select a parent folder to add a building or partition.
  1. In the Output expander, from the Application drop-down list, select the type of report, which in this case can be:
  • DMS Report (Alarm Summary Report)
  • DMS Report (Door Access Summary report)
  • The parameters fields for the selected report are displayed underneath.
  1. Do not modify the Report Template. This corresponds to selected report type.
  1. If the report is intended for manual execution in the viewer:
  • In the Format field select html.
  • There is no need to set the remaining fields, as the values set here will not apply when a report is executed manually. When a report is executed in Application Viewer, the parameters applied will be those entered by the operator into the Parameters dialog box.
  1. If the report is intended for scheduled/automated execution, for example in a reaction or script:
  • In the Format field select pdf, docx, or xslx.
  • Set the remaining fields as required. The values set here will be propagated to any fixed link you create from this rule. But you can also adjust these parameters in the fixed links themselves.
  1. Click Save As .
  1. In the Save Object As dialog box, select the Application Link Rules destination folder, then enter a name and description for the report rule.
  1. Click OK.

 

Create a Link to Execute a DMS Report

Operators can run a DMS report by selecting a target object for which a report rule was configured, as described above. However, you can also provide a link through which an operator can directly run a report, without having to find the target object. These links are also used for the automated execution of reports, in macros, scripts or reactions.

  • System Manager is in Operating mode.
  1. In System Browser, select the target object of the report rule.
  1. In the Application Viewer tab, select the desired report.
    NOTE: If the target object has only one associated report, it is automatically selected.
  • The Parameters dialog box for the report displays. However you do not need to configure these here, as the entered values will not be stored in the link.
    Instead, the parameter values stored in the link are those set in the Output expander of the report rule.
  1. Click Save As .
  1. In the Save As dialog box, enter the name and description for the link.
  • The saved link displays in the Applications > Links folder. If you select the link, the Extended Operation tab shows the report parameters configured in the report rule.
    To test the link see Execute a DMS Report from a Link.

 

Set Credentials and Parameters for a DMS Report Link

When a link is manually selected by an operator, the corresponding report is executed with the operator's credentials, and applying the parameters that the operator enters in the Parameter dialog box. However, if a link will be used for automated execution of a report, you must configure the credentials under which the report will be executed, and the parameter values to apply.

  • System Manager is in Operating mode.
  • System Browser is in Application View.
  1. In System Browser, select Applications > Links > [DMS Report link].
  1. Click Set Credentials .
  1. From the drop-down list, select the User Account under which the report will be executed.
  1. Click OK.
  1. In the Extended Operation tab, adjust the values P2 through P9 as required.
    These parameter values will be applied when the report link is automatically executed, for example in a script or reaction. In particular:
  • The P2 value must be PDF, DOCX, or XSLS. This allows the automated report output to be saved to a file.

Automate Execution of a DMS Report

You can configure a reaction that, for example, executes a report at specified intervals, and stores the output on disk, or sends it to an email recipient.

  • System Manager is in Engineering mode.
  • System Browser is in Management View.
  1. In System Browser select Applications > Logic > Reactions.
  1. Select the Reaction tab.
  1. Open the Triggers expander and then open the Time and Organization Modes expander.
  1. Set when you want the report to be generated. For example, to run the report every working day at 6pm:
  • In Set Start Time enter 6:00:00 PM.
  • Deselect the Set End Time check box.
  • Under Effective Days set the Recurrence to Weekly (every 1 week on...) and select the check boxes for days Monday through Friday.
  1. Open the Output expander and then open the Actions expander.
  1. From under Applications > Links, drag the desired report link into the Scope/Target area.
  1. Expand the parameters in the Command column.
  1. From the drop-down list at the top, select either:
  • Execute: The report output will be saved to a file on disk.
  • Email: The report output will be saved to a file on disk, and also emailed as an attachment to the configured recipient.
  1. From the Output Format drop-down list, select PDF, XSLX, or DOCX.
    NOTE: This value must match the P2 value configured in the Extended Operation tab for the report link. See Set Credentials and Parameters for a Report Link.
  1. In the File Name field, enter the prefix for naming the report output files. This will be concatenated with the timestamp to form the file name.
  1. In File Path, enter the location on disk where the report files will be stored.
  1. In Section, select Save document.
  1. In the Time Stamp field, enter the desired format for the timestamp that is appended to the report name. For example, dd-mm-yy-hh-mm.
  1. Click Save As .
  1. In the Save Object As dialog:
  • Select the location where you want to save the reaction.
  • Enter a name and description for the reaction.
  1. Click OK.
  • The report will be automatically executed with the specified schedule (every workday at 6pm) and the output saved as a file on disk.