View SSRS Report in Sharepoint Web Part

In order to view SSRS report in Sharepoint Web part follow the steps:

1. Complete all the steps as per last post- for integrating SSRS with MOSS 2007

2. On successful completion of integration, 

• Go to your Sharepoint site settings.
  
• Under Library -> click on Report Library
• Upload your SSRS report rdl file under this report library folder
• Once report is uploaded, right click report and click on Data sources
• Update datasources with proper credential information.
• On completing this stuff, your SSRS report will be ready to deploy on sharepoint site.

3. Now it is time to view report on sharepoint site.

• Open sharepoint site
• Edit your page
• Click on add new web part
• Add a web part called, SQL Server Reporting Services Report Viewer
• Open Report viewer web part properties
• Select Report location using report browser. (Note: Your reports will be under your report library)

You are all set!! Sharepoint web part will show the report under sharepoint context.