We can automate a report to be run automatically at specific dates/times by using the report scheduling; this will help to improve the report performance while having the report ready for the user whenever he needs it. The quickest and easiest way is by creating a report snapshot through the report scheduling directly from the Dynamics CRM interface, as we will see next.
Dynamics CRM 2011 has some native features that allow us to automate the SSRS reports that we create with either the CRM Report Wizard or with Visual Studio by configuring an automated run schedule. This feature is available in the Reports ribbon in the Actions group under the Schedule Report button, as shown in the following screenshot:
When we click on this button, we will be presented with a dialog that will have two options:
On demand
On a schedule
These options will generate snapshots of the report whenever we specify; if we select On a schedule, we will be able to specify a recurrence...