Pro SQL Server 2012 Reporting Services

CHAPTER 10  MANAGING REPORTS

 Note You’ll need to set up these shared schedules in advance using Report Manager on your SSRS 2008

server. You can add and edit shared schedules by navigating to your SSRS 2012 server with your Web browser,

selecting Site Settings, and then under Schedules, select New Schedule. You can also use SSMS to set up shared

schedules. By default, you need to set up these shared schedules as a user who is in the SSRS 2012 System

Administrator role, and users who access them must be members of the System User role. In addition,

subscriptions require that the SQL Server Agent is running and that your data source have stored credentials. See

the “Setting Up Shared Schedules” section earlier in this chapter for details.

Next, take the URL that is passed in when the PickSchedule class is initialized and break it apart to

get the report name for which you are setting the schedule. Add the code in Listing 10-5 to the class’s

constructor.

Listing 10-5. PickSchedule Constructor

public PickSchedule(string URL)

{

InitializeComponent();

url = URL;

string[] reportInfo = url.Split('?');

server = reportInfo[0];

report = reportInfo[1];

}

 Note The call to InitializeComponent is present in the constructor already. It was added automatically when the

form was created.

To get a list of available shared schedules from your SSRS 2012 server, you’ll use the ListSchedules

method of the Report Server Web service. The ListSchedules method returns an array of Schedule

objects, so after you call the method, you’ll need to loop through the array to populate your combo box.

Since we are expanding on the SSRS Viewer RVC project that we created in Chapter 9, we need to add

two new options to our PickSchedule_Load event as shown in Listing 10-6. To do this, add a Do Not

Schedule choice and a Schedule with Snapshot choice to your combo box.

 Note You can set up snapshots through the Report Manager Web interface of your SSRS 2012 server.