Scheduled Reports

Information

Scheduled Reports deliver Saved Searches or Report Writer Reports to select users via email in CSV, Excel or HTML format. This allows interested parties to receive and review the most current data without requiring them to log into the system to retrieve it. All output delivered in Scheduled Reports will be filtered based on user permissions on a per-user basis.

Add a Scheduled Report

To create a Scheduled Report:

  1. Navigate to: Home > Reports > Scheduled Reports > Add.
  2. Enter a name for your Scheduled Report.
  3. Select what Report Type you want.  This selection determines the input criteria for the report.
    1. Saved Search is a type of report that is created from the Search Issues screen. 
    2. Report Writer Report is a type of report that is generated from Report Writer.
  4. Choose an Output Type

  5. Determine the Schedule for this scheduled report.  There are many choices on this menu, but notably:
    1. If you choose Hourly, you can set the scheduled report to be run only during specific hours.
    2. If you choose Daily, you can set the scheduled report to run at a specific time. 
    3. If you choose Weekly, you can set the scheduled report to be run only on specific days.
  6. (Optional) Enter the End Date

  7. (Optional) In the event that this scheduled report fails to be generated, you can configure Issuetrak to notify a designee that something went wrong by selecting them in the Notify on Error field.
  8. (Optional) Enter a comment or description for this scheduled report.

  9. Once the appropriate fields have been entered, click Save.

The Scheduled Reports List will appear with the message “Report successfully scheduled” upon completion.

The Report Distribution List can only be added or maintained after a Scheduled Report has been added. If a user or group has been defined in the “Notify on Error” field in the Add Scheduled Report screen, this user or group will be a member of the Report Distribution by default.

Edit a Scheduled Report

  1. Navigate to: Home > Reports > Scheduled Reports.
  2. Click edit next to the appropriate Scheduled Report from the displayed list of Scheduled Reports.
  3. You may make changes to the fields that were set when the report was added.  Note that there are three things on this screen that are not visible from the "Add Scheduled Report" screen:
    1. Next Run Date.  This is the next time that the report is scheduled to be run. 

      Note that the Windows Scheduled Task for Scheduled Reports actually determines when Scheduled Reports are run.  The task runs on an hourly basis, but its exact run time may differ from "on-the-hour" times set in the interface.  Therefore, if you have a report that is scheduled to run at 9:00 AM, and your Scheduled Task last run time was 8:50 AM, you can expect to receive your 9:00 AM report around 9:50 AM when the Scheduled Task runs again. 
       
    2. Enable Test Run.  This tells the system to run this report on the Scheduled Task's next run time, regardless of this report's scheduled frequency. 
    3. Report Distribution.  This determines who the report is sent to. 
  4. Once you have changed the Scheduled Report to your liking, click Update to apply the changes.

The message “Report Schedule successfully updated” will display upon completion.


Demonstration Video

The video below is pre-11.8, but the information is still applicable. The only differences with 11.8 and newer are:

  • The ability to set the output format to CSV
  • The ability to send scheduled reports on an hourly basis