21 Apr, 2008
SQL Reporting Server 2005 fast overview
Posted by: Anca Alimanescu In: Business Intelligence
What it does :
Enables the creation, management and delivery of both traditional, paper-oriented reports and the interactive Webbased reports(integrated part of the Microsoft Business Intelligence framework).
Architecture
Tools used :
- Reporting Services Configuration
- Report Manager
- Report Builder
- Report Designer
- Model Designer
Adding reports directly to the server:
- Using Report Designer from Visual Studio Business Intelligence
- Using the programatic interfaces availbale
Management of reports :
- using Report Manager from Visual Studio Business Intelligence
- using the programatic interfaces availbale
How to access the SRSS programaticly :
- URL Access
- Webservice
- Windows Management Instrumentation
Webservices exposed :
- ReportExecution2005 – programmatically process and render reports from a Report Server
- ReportService2005 – allows the programmers to programmatically manage objects from Report Server
Note : The webservices can be used only in applications that use the .Net framework
Tags: SQL Reporting Services, SQL Server
