Configure Automated Reports

EMS is able to send reports daily to selected email addresses. Reports that can currently be automated to send are Reservation and Sales\Statistics Queries and all Saved Daily and Statistics Reports under the EMS Reports menu. To learn more, see creating Queries or Saved Reports. Automated Reports can be set up and emailed to selected individuals. Automated Reports use predefined Queries and Saved Reports. An email will be sent to the users defined in the Automated Report Delivery with either the information requested through the report or with an email stating there was no data to display.

For Automated Reports to be sent, the EMS Automated Report service needs to be installed and configured. For directions on installing and configuring the service, see Installing the EMS Automated Report Service.

  1. On the EMS menu bar, click Reports Automated Report Delivery

    The Automated Report Delivery window opens. This window lists all Automated Reports that are currently configured in your EMS database and that have a status of Active.

    https://success.emssoftware.com/@api/deki/files/1414/Automated_Report_Delivery.gif?revision=4

    Note:

    To view any deactivated Automated Reports check the Inactive checkbox in the Show section of the window.

  2. Click New

    The Automated Report window opens.

    https://success.emssoftware.com/@api/deki/files/1415/Automated_Report_Config.gif?revision=3

  3. In the Description field, enter a name or description for the new Automated Report. 

    The Automated Report Delivery description should specify the type of delivery, such as Daily Event Schedule Delivery.

  4. In the Automated Report Type area, specify if this report is a Query or Saved Report.

    https://success.emssoftware.com/@api/deki/files/1423/Report_Type_Query1.gif?revision=3

  5. Specify the Frequency using the options described in the following list:

    https://success.emssoftware.com/@api/deki/files/1428/Frequency.gif?revision=3

    • Daily/Weekly/Monthly: Determines the frequency that the report will send.

      • Daily: will send every day at the specified time.

      • Weekly: Can be set to a single day every week or multiple days every week.

      • Monthly: Can specify a specific day each month (1-28) or the last day of the month.

    • Send Report At: Determines the time each day that the Automated Report will send.

    • Time Zone: Determines the time zone for the time selected for the report to send. Time and Time Zone correlate to the database server and the server on which the Automated Report Service is installed.

    • Reporting Period: Determines the dates which the report will be automated for. Choose from multiple options in the field to customize the reports.

  6. Specify Email Settings and Email Recipients using the options described in the following list:

    https://success.emssoftware.com/@api/deki/files/1431/Email_Settings.gif?revision=3

    • Email From: Enter the Email From address for the Automated Report.

      • If you leave the Email From field blank, then the Email From address entered in the EMS Automated Report Service is used.

    • Email Subject: Enter the title for the email that will contain the Automated Report.

      • If the Subject line is left blank, the Automated Report description will be used as the email subject.

      • A variable can be used to put information into the subject line as described in the Legend. %1% is the code for the Reporting Period, so "Event Schedule for %1%" results in "Event Schedule for Tomorrow" being displayed in the subject line.

      • You can look up Email Addresses by clicking the Add button, which selects from the Global Address Book. In the Email Address field, for each user and/or group that is to receive the Automated Report, enter the appropriate email address, and then click Add.