Salesforce Report Scheduler

Scenario:

When a customer requests to receive a report daily or weekly without having to login to Salesforce.

Salesforce user can schedule reports to be automatically sent as a html email on preferred time. [More info here]

Setting up schedule report

Red Box: Button will only show if the report is already in the scheduled list.

Green Box: Send report to the recipient.

Purple Box: Schedule date and time.

Scheduling Time

There is only 3 options available and this CAN NOT be changed. Salesforce advises to schedule report off-peak hours of local time. [Source here]

To monitor all scheduled reports, go to Setup | Monitoring | Scheduled Jobs.

Emailed Report

When it is time, Salesforce will send the report to recipient’s email. This is how it looks like:

Note

Bare in mind that:
– Reports with types of Joined CAN NOT be scheduled.
– Report charts are not included in email (Solution is to create chart as dashboard and schedule dashboard refresh)
– Reports with table more than 22″ wide or more than 63 columns might not be able to display properly in Outlook 2007.
– Emailed reports have a maximum size of 10MB.

For more information, click here.