Ssrs, Moss and WebServices Integration

Following  are the steps that are executed, when a report is open from sharepoint

1.The report server proxy endpoint connects to a report server

2.Creates a session

3.Prepares the report for processing

4.Retrives data

5.Merges the report into the report layout

6.Displays it in the ReportViewer Web part

The figure below represents the server architecture:

Advantages of this architecture

1. Uses Sharepoint content database

2. Browse sharepoint libraries for report server content types

3. Same permission levels as other documents

4. Use collaboration and document management features

5. To check reports in and out

6. Use alerts

7. Embed or customize the Report Viewer Web part on pages and sites within the application

Following is the figure of the dashboard created using dundas charts