Many clients have a requirement of receiving the ORD or Table reports to their email. The new Scheduler in Report Center is only available for destination as either Offline or File Transfer Protocol. This blog is to explain the configurations related to the Legacy Report Scheduler through which we can send reports to email.
Please make sure that Report center is enabled, and the admin has respective permissions for configuration
Navigation:
Report Centre > View Schedules > Switch to Legacy report Distributor Tool
Design a Report:
First you should have a report designed which should be sent through email.
In my case, requirement was to send the data from EC which was modified from last successful run.
Hence, I have incorporated field selection filter to the ‘Last Modified Date’ as below
Configuration:
The Legacy distributor page looks like below, the scheduling of the reports and the recipients comes under the concept of Bundle.
First you create a bundle, each new bundle creation will ask you to decide on below parameter.
Bundle Name is the name for group of reports you want to schedule.
Page size is basically the report size, i found the A3 is bigger in size compared to others.
A limitation here is that the system allows only to distribute only PDF, Microsoft Word (doc and docx) and Microsoft PowerPoint (ppt and pptx) .
Hence when designing the report be careful on the number of columns used. If the report has more columns than the ones which can’t be fit inside the PDF report, then we might have to opt for offline download feature rather than email or FTP.
Each bundle will then have 4 tabs: Items, Destination, recipients and Schedule.
Items is to select the report you want to add to the bundle. Click on Add Item and select the reports.
In my example, I will be adding 4 reports into this bundle.
The second tab
Destination is to decide whether the report destination should be
offline,
FTP or
email. (If we are opting for FTP and Offline, we can go for new scheduler instead of using legacy ones.)
Select the email as destination.
You have edit recipients under email radio button which will take you to next tab
Recipients.
Click on add recipients and select the ones who should receive the mailers with the report attached.
In case you do not find the user in the list, please ask the user to access the report center page or proxy as user and go to the report center page. As soon as the user access the report center, the recipient list will be synched and will be available for selection as recipient.
Note: If you want to manually sync the any user’s specific data please got to Admin > User Maintenance
Bulk user Load is to import the list of users. It is suggested to not use the add new user manually in using user Maintenance.
Before Scheduling the report lets design the email format that recipients are supposed to receive once the scheduled jobs are completed.
The email can be designed by selected Edit Email in the bundle,
There are 3 options.
- Default: This email format is used to all bundles which do not have its own email override format. I recommend we always opt for Override for bundle instead of default.
- Override for bundle: This is email format designed for respective bundles. Edit this section and design on how the email should be sent to the recipients.
- On Completion: On completion email is sent to the admin who scheduled the report distributor. This email will consist of the logs and status of the scheduled job.
We can use 3 tags [USERNAME], [FULLNAME] and [EMAIL] to address the user.
If we leave the Address Prefix in the email format as blank, recipient will receive email from
Reportnig@successfactors.com. If you want to customize the email sender address as clientname@successfactors.com or
clientnameHR@successfactors.com. Input the prefix in the
From address prefix field.
Once the emails are configured, lets
schedule the report
Screenshot of email received by the sender after the job completion.
Screenshot of email received by the recipients.
Thank you!