Database Reference
In-Depth Information
Figure 16-5.
Report Viewer as shown from the web service and Report Manager
As you develop your reports, it is best to make sure you view the reports using both of these methods to
ensure that what users are seeing is sufficient for their needs.
SSRS Services
Once you are done creating and testing a report, you can upload the file to the SSRS web service using Visual
Studio, Report Builder, the Report Manager website, or even a SharePoint website. This variety of options is made
possible because all of these applications can interact with the SSRS web service. This flexibility is one of the
reasons why Microsoft designed Reporting Services to use a web service for the report processing.
In addition, the web service acts as a public interface for the SSRS Windows service, allowing Visual Studio,
Report Builder, the SSRS Report Manager, SharePoint, and other software to interact with the SSRS windows
service through an abstraction layer.
The web and Windows services' purpose is to process the programming instructions found in RDL files. The
contents of the RDL files will be stored in a pair of SQL Server databases (Figure
16-6
).
