You design a Business Intelligence (BI) solution by using SQL Server 2008. You have developed SQL Server 2008 Reporting Services (SSRS) reports that are deployed on an SSRS instance.
You plan to develop a new application to view the reports. The application will be developed by using Microsoft ASP.NET 3.5.
You need to ensure that the application can perform the following tasks:
-Display available reports in a tree view control.
-Create and manage subscriptions on reports.
What should you do?
A.
Configure the ASP.NET application to use the SSRS Web service.
B.
Configure the ASP.NET application to use URL access along with the Command parameter.
C.
Embed a ReportViewer control in the ASP.NET application. Configure the control to use the local processing mode.
D.
Embed a ReportViewer control in the ASP.NET application. Configure the control to use the remote processing mode.
Explanation:
Tip: "tree view control" = "SSRS Web service"Report Server Web Service
The Report Server Web service is the core engine for all on-demand report and model processing requests that are initiated by a user or application in real time, including most requests that are directed to and from Report Manager. It includes more than 70 public methods for you to access SSRS functionality programmatically. The Report Manager Web site accesses these Web services to provide report rendering and other functionality. Also,other integrated applications, such as the Report Center in Office SharePoint Server 2007, call SSRS Web services to serve up deployed reports to authorized end users. The Report Server Web service performs end-to-end processing for reports that run on demand. To support interactive processing, the Web service authenticates the user and checks the authorization rules prior to handing a request. The Web service supports the default Windows security extension and custom authentication extensions. The Web service
is also the primary programmatic interface for custom applications that integrate with Report Server, although its use is not required. If you plan to develop a custom interface for your reports, rather than using the provided Web site or some other integrated application (such as Office SharePoint Server 2007), youll want to explore the SQL Server Books Online topic Reporting Services Web Services Class Library. There you can examine specific Web methods.
(Smart Business Intelligence Solutions with Microsoft SQL Server 2008, Copyright 2009 by Kevin Goff and Lynn Langit)