Working with Reporting Services Using Microsoft Sharepoint
Introduction
There are many instances in which the business process requires executive reports or some company performance reports to show up on intranet sites. Companies do use different portals to build their intranet sites. Microsoft’s SharePoint technology is one such tool. The main task is how we display the reports stored under SQL Reporting Services on the SharePoint site. Microsoft does provide two Web parts with SQL Reporting Services SP 2. In this section I will share information on using the current web parts provided by Microsoft and then explain what exactly happens behind the scenes to display the report. Finally I will explain how you could create your own web part.
The two web parts provided by Microsoft are Report Explorer and Report Viewer.
Click on the link below to read the complete article
Working with Reporting Services Using Microsoft Sharepoint