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
Uses Sharepoint content database
Browse sharepoint libraries for report server content types
Same permission levels as other documents
Use collaboration and document management features
To check reports in and out
Use alerts
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