Integrating Reporting Services with SharePoint in native mode-Collection of common programming errors
Hi Connie,
If we are not able to configure the SQL Server Reporting Services(SSRS) with SharePoint Integration mode, and we want to display a report from a native SSRS report server, we can use the Page Viewer web part.
In a SharePoint page, add a Page Viewer web part to the page, set the URL of the Page Viewer web part to be the URL Access of a report. e.g. http://sha-jc-vm1/ReportServer?/AdventureWorks+2008+Sample+Reports%2fCompany+Sales+2008
For more information, please see:
About the Page Viewer Web Part: http://office.microsoft.com/en-us/windows-sharepoint-services-help/about-the-page-viewer-web-part-HA001160926.aspx
URL Access: http://msdn.microsoft.com/en-us/library/ms153586.aspx
If there is anything unclear, please feel free to ask.
Thanks,
Jin Chen