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.
As well, reports saved in the Scheduled Reports folder can only be scheduled by the owner of the report, and instances scheduled by one user cannot be edited by other users. To get around only a report owner being able to schedule the report, please save the report in a different folder.
To Schedule:
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
Formats:
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. Also, if an Excel format is selected, and the scheduler wishes to view or change the report, they will have to open it by right-clicking on the report name and selecting Modify.
Destinations:
We only currently support Email and SFTP destinations.
Clicking the destination link listed allows you to further specify destination details like the recipients.
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 "noreply@socialsolutions.com"
Note: There is a 10MB size limit on emailed scheduled reports.
Note: Remove the placeholder from the To: email before adding the necessary recipient addresses
SFTP
Best Practices for Scheduling Reports
Do not schedule more than 3 reports for the same hour (per user).
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:00 a.m. and 4:00 a.m. (Eastern Time).
To change recipients for a scheduled report, you must stop the original instance and create a new one with the correct and new recipients.
Separate multiple email addresses with a comma.
Only the scheduler of the report will be able to see the schedule history they have created for the report.
Common Errors
Schedule report error: write error. [Error sending mail message to SMTP server. Return code: [552].]: [CrystalEnterprise.Smtp]
Your report is probably hitting the maximum size limits. Be sure the exported file would not exceed 10 MB.