Pro SQL Server 2012 Reporting Services

(sharon) #1

CHAPTER 9  RENDERING REPORTS FROM .NET APPLICATIONS


Figure 9-12. Finalized Web report application

Summary

In this chapter, we showed how to use the URL access capabilities of SSRS 2012 and the Report Viewer
controls to embed reports quickly into applications. Beyond the WebBrowser and Report Viewer
controls used in this chapter, you can use other applications to render reports. For example, you can
integrate SSRS 2012 with Microsoft SharePoint Server. We’ll discuss using this integration in greater
detail in Chapter 12. By combining SharePoint and SSRS, you can quickly build a portal that displays
your reports without much code at all.
In this chapter, you also learned how to make Report Server Web service calls to augment your
Windows Forms viewer application. The application you created allows you to type the URL of a server-
based report you want to view. It then uses SSRS 2012’s GetItemParameters method to retrieve a list of
report parameters and the ValidValues property to retrieve possible values. It then reads the values
selected by the user and populates an array of ReportParameters which is then used by the Report
Viewer control to render your report with the selected parameters already in place. In Chapter 10, we’ll
expand on this example by using the Report Server Web service to allow the user to set the report to run
on a schedule with the supplied parameters instead of rendering it immediately.
Free download pdf