If a user wants to be able to share with other users, the report should be placed into a folder named “Scheduled Reports.”
Reports can be scheduled from ANY folder. However, if the report is placed inside of the Scheduled Reports folder, the report is not available for users to run as a regular report (ability to run, refresh, etc). This will allow an Administrator to prevent users from running the long-running reports and to more simply focus on the instances.
Step 1 - Find the report, right click, and hit 'Schedule'
Step 2 - When the report is set to schedule, the user will be prompted to provide an Instance Title. This is the name of the scheduled report.
- This will be the text the user sees on the View Reports page. By default the name of the report is provided.
Step 3 - After the Instance Title is provided the user will set the Recurrence. This is where the user will select how frequently the report is to run.
- The only non-supported option is "Calendar." If the user selects this option, a message will return that says "There are no calendars."
- If the user selects "Now" for the Recurrence, this will indicate that the report is to run with the current data set. However, the report can be scheduled to run at any time with this data set. If the report contains prompts, then they must be supplied when scheduling the report.
- Note: Prompts will automatically populate with the last-run or saved data for the report. To change the prompt, select the “Modify” option.
Formats and Destinations
This is where the user will select how the report is delivered to other users. The first option is the Output Format. Note the Supported Models below, as there are some formats that are not supported. Note: Plain Test and CSV formats will be the smallest in file size.
- Inbox: This option will create a link on the View Reports page of an instance of the report. The instance can be selected to be in either Excel or Web Intelligence format. The instance can also be viewed in the Reporting Dashboard as a link. Please note that this option does not send an email to a user's email inbox; the inbox is a feature inside the Reporting Dashboard. This option allows the report writer to make the report available to a subset of users. Selecting this option and making no further specifications delivers the report to the Inbox of the user doing the scheduling. To distribute the report to more users click "Destination Options and Settings." Deselect the pre-checked option for "Use Job Server's Defaults." Select users and/or groups. Keep in mind that all the users that are selected will receive the instance of the report matching the security of the user scheduling the report. For instance, if an Enterprise Manager schedules the report for a Staff level user, the staff person will see data across the enterprise. Selecting individual users may be difficult; the user names listed match the Live Office login information found under My Account. Building a report using the Standard Reference Universe will return individual user's Live Office Account Info
- Email Recipients: Delivers specified format of report instance to specified users. The best output format is either Excel or PDF. If the user selects "Web Intelligence" the report will only open in the Web Intelligence Rich Client application. Like the Inbox option the user must select "Destination Options and Settings" and deselect the "Use Job Server's Defaults" option. Also, "Add attachment" must be selected for the report to be sent to the user. If it is not selected the email will contain a message that indicates that the report is complete, but the report will not be sent with the email.
Note: the From field should be filled in as "email@example.com"
Note: There is a 10MB size limit on emailed scheduled reports.
Best Practices for Scheduling Reports
- Do not schedule more than 6 reports for the same hour
- Space report run and end times out so that none overlap
- Make the start and end times exactly 10 minutes apart
- Do not run reports while servers restart between 3:00am and 4:00 am (eastern time)