IT Reflexions

21 Apr, 2008

SQL Reporting Server 2005 fast overview

Posted by: Anca A. 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