Viewing SQL Reports in SharePoint WebParts using SQL Reporting Service.
PreRequisites:
1. Sql Server Reporting Services.
2. Windows Sharepoint Services.
If you have installed SQL 2005 Reporting Services in your System by default you will have the RSWebParts.cab in your system.
MSDN Article for Steps to install Report ViewerYou add this webpart to your sharepoint site using STSADM.exe.
Before that you have to create the report in SQL Report.
Then you have to host the report in to SQL Reporting Services.
Finally, provide report url property for report viewer webpart in sharepoint page.
Steps:
1. Install the Report Viewer WebPart to Sharepoint Sites.
2. Create the Report in SQL.
3. Host the Report in SQL Reporting Services.
4. Create an Webpart Page in Sharepoint site.
5. Drag and Drop the webpart ReportViewer in Virtual Server Gallery.
6. Fill the property of webpart with the Report URL.
7. Lets Refresh the Page Report is ready to view in sharepoint site.
