dotnet Report Builder allows users to create a schedule when designing reports. This feature allows users to run reports automatically and email them to specified email addresses.
To start scheduling reports, click on the check box for “Schedule Report” in the Report Designer as shown:
When report scheduling in enabled, end-users can set up the report running schedule as well as decide who the reports are sent to. The reports are sent via email in Excel format.
Setting up a Report Schedule
Reports can be scheduled to run at a specific time in four scenarios:
- Daily
- Certain days of the week
- Monthly on a specific date
- Yearly on Specific dates on specific months
Sending Scheduled Reports
Scheduled reports are sent via email as MS Excel attachments. To send reports to multiple recipients, separate email addresses with commas as shown below.
Configuration for Email Scheduler
The scheduled report code runs using the DotnetReportJob.cs code in the front end.
Need to make sure to Start the Job on app start in Global.asax:
JobScheduler.Start();
Report scheduler uses email settings exist in web.config file of project, so these must be added as well.
Here is a quick view of just setting up email configuration.