Scheduling Reports

The Scheduled Reports tab under your User Profile allows you to schedule reports to run at a particular day and time and have the results e-mailed to you. You can easily schedule reports to execute and send to the e-mail address specified in your user account on a recurring basis by simply selecting a report to run, the frequency it should run, and the exact time it should be executed.

Note: The report is generated and the e-mail is sent according to the Time Zone specified in your User Profile.

The scheduled report runs at the selected time and then the results are e-mailed. This means there might be a delay between the time the report is run and when the e-mail is received.

The e-mail message includes a PDF attachment that contains the report results. For the following report types, users can choose to send report data in a PDF or a zipped Excel document:

Listing
Reports with join conditions
Change History
Deleted Items
State Change
Version Control Actions
Multi-Table

Only the first 10 columns are included in PDF reports that return a list of items, such as those above. PDF results for list-type reports are limited to 200 items by default. Your administrator can change this setting, however.

Note the following additional information:

The maximum number of items that are allowed in these types of reports is determined by your administrator.
You cannot schedule Drill Through, Details, Calendar, and Application reports.
You can click the values that appear in a tabular Distribution report to view a list of items. Similarly, if the report contains drill-down options, you can click them in the PDF. However, the scheduled report output might not match the current report output because the scheduled report was created in the past.
For Multi-View reports, a separate PDF or zip file is attached for each report.
Reports may be restricted due to size, since large PDF files may not be supported by your e-mail server.
Tabular reports with a very large number of columns do not display properly and are therefore discouraged. For example, a Trend report with fifteen columns is loaded with information, but still readable. A report with thirty columns is not as easy to read.
External server links in tabular reports will not work. Only internal server links are supported.

To create a new scheduled report:

Create and save your report as described under Creating and Editing Custom Reports.
Edit your User Profile by clicking your name.
On the Scheduled Reports tab, click Add.
Select an application from the Application drop-down list. The report search results are filtered by the application that you select.
In the Search for Reports field, enter all or part of the report title, or part of a word in the title. Click the search icon or press Enter. A list of reports that match the search criteria are returned.
Restriction: You cannot schedule reports that require query-at-runtime parameters.
Select a report and click OK. The report title appears with a description of the current schedule (the default is Daily at 12:00 AM).

Select the frequency or date as follows:

Frequency	Options
Daily	Select a time value to have the results e-mailed to you at the same time every day.
Weekly	Select the days of the week and the time each day to have the results e-mailed to you at the same time each day, each week.
Monthly	Select one or more days of the month and the time each day to have results e-mailed to you on the same days, at the same time, each month. Note: To accommodate every month of the year, you can schedule monthly reports to be generated and e-mailed on any day between the first day of the month and the 28th day of the month or the last day of the month.
On Date	Select a single day and time to have the results e-mailed to you only once.

In the Cc field, enter all or part of a user name or group to copy other users to the scheduled report e-mail.
Note: The ability to Cc users and groups is controlled by a privilege that is set by your administrator.
Click Show Advanced Options to use the following options:
- E-mail template
  Select an e-mail template to use for the scheduled report. The available templates are managed by your administrator. Administrators can create and edit scheduled report e-mail templates (including the sr_scheduled_reports.htm/.txt templates) in SBM Application Administrator.
- Preview
  Preview the scheduled report notification message. The preview contains text for successful reports and failed reports.
- Link type
  Select the link type that should appear in scheduled report e-mails. This controls which interface is used to view the results of the report (SBM User Workspace or SBM Work Center) when the user click the results link in the e-mail or in the PDF.
- Result type
  Depending on the type of report, use this option to send the results in either an Excel file or a PDF.
- Suppress e-mail if there are no report results
  Select this check box to suppress the scheduled report e-mail if the report does not contain any results. Only applies to listing reports.
In the summary that appears, you can delete the scheduled report that you just created or add another scheduled report. Click Save Profile to save your changes and finish.

The Scheduled Reports tab displays a list of reports that you have scheduled to run at a particular time. You can delete current items in the list by clicking Delete or you can modify them selecting the report and changing the existing schedule parameters.

Scheduling Reports

Related Topics