Open the Table of Contents

Managing Custom Reports

This section is meant for administrators with 'Super User' or 'Batch Code Admin' role.

Sentinel EMS provides a set of standard reports. However, if these reports do not have exactly what your users want you can define custom reports according to your requirement. To create custom reports, you need to be aware of the data model of Sentinel EMS. The detailed database schema is available in the Sentinel EMS Configuration Guide.

Creating/Updating a Custom Report

• On the main menu, click Administration > Custom Reports. The Custom Reports page appears.
• Click New Report. The Create Custom Report pop-up appears.

  

  To update a custom report, select it and click . The Edit Custom Report pop-up is displayed.

• To update a custom report, select it and click . The Edit Custom Report pop-up is displayed.
• In the Name field, provide a name for the report (maximum length 50 characters).
• To enable the report, select the Enabled check box. You can leave it unchecked to create the report in disabled state. You can enable/disable the report later.
• Specify the output format for the report in the Report Format drop-down list:
  • CSV—Select this if you want to get the output in CSV format.
  • Jasper—Select this if you want the output in CSV/PDF/HTML/RTF format. For this, you need to create the Jasper report template beforehand.
• In the Query field, write a SQL query. Following is an example of a simple query:

  select * from T_ENT_Activation

• For Jasper report, upload the Jasper template in the Report Template field.

While creating a 'jrxml' file, replace the text [language="groovy"] with [language="java"] as Sentinel EMS does not support Groovy.

• Click Validate to validate the SQL query.
• Click Save.

You can create scheduled reports for custom reports.

Enabling/Disabling a Custom Report

If a custom report is disabled it won't appear in the reports list. You need to enable it to make it available to the users.

• Select a custom report.
• Click and select Enable (or Disable) to enable (or disable) the report.

Deleting a Custom Report

A custom report cannot be deleted if a scheduled report exists for it.

• Select a custom report from the left pane.
• Click Actions > Delete.
• In the pop-up that appears, click Yes.
  

Running a Custom Report

Running a custom report is no different from running a pre-defined report.

1. On the main menu, click Reports. The Reports page appears.
2. At the bottom of the left pane, all available custom reports are displayed under the Custom Reports tab.
3. Select a report.
4. Select the output type from the Output Format drop-down list.
5. Click Generate Report.