Pro SQL Server 2012 Reporting Services

CHAPTER 10  MANAGING REPORTS

Figure 10-1. Choosing the last day of the month

Next, select an appropriate start date and end date for the schedule (in this case, don’t specify an

end date), and then click the OK button. Now you can move on and prepare the report itself to use the

new schedule. As a note, schedules in SSRS rely on the SQL Server Agent service, and as such, the service

must be running before you can successfully create a schedule.

 Note Note that when a job, such as a subscription or an execution snapshot, is scheduled to run within SSRS, a

SQL Server job is created using the SQL Server Agent. Jobs can be monitored through SSMS or Report Manager.

Configuring a Report to Use a Shared Schedule

The AR Reconciliation report contains report parameters that can limit the data displayed on the report.

Two of the parameters, AcctPeriodYear and AcctPeriodMonth, are used in the driving stored procedure

to limit financial data to an accounting period. When the AR Reconciliation report is executed from a