Pro SQL Server 2012 Reporting Services

(sharon) #1

CHAPTER 9  RENDERING REPORTS FROM .NET APPLICATIONS


Listing 9-2. The runServer Click Event: Running Report in Remote Mode

private void runServer_Click(object sender, EventArgs e) {
reportURL.Text = "/Pro_SSRS/Chapter_9/EmployeeServiceCost";
reportViewer.ProcessingMode =
sProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl = new Uri(@"http://localhost/reportserver/");
reportViewer.ServerReport.ReportPath = reportURL.Text;
reportViewer.RefreshReport(); }

Now run the project in debug mode. Then click Run Server. This renders the Employee Service Cost
report where you can input parameters for your report. Of course, you need to use the name of your
report server where you see localhost in Listing 9-2. At this point, you should see something that looks
like Figure 9-4.

Figure 9-4. SSRS Viewer RVC running a server rendered report

That’s all there is to rendering a report on an SSRS 2012 server using the Report Viewer control.
Free download pdf