Using SQL Reporting Services with in Microsoft Sharepoint in native Mode
If you need to display Reports developed using SQL Reporting services there are two options. Either you use you Share point Server in integrated mode with SQL Server Reporting services or you may use it in Native Mode. Following defines the steps you need to perform in oder to use reports in Native Mode. Microsoft provide report explorer and report viewer web part to display and browse reports deployed at MS SQL Server Reporting Server. But these web parts are not installed by default so you need to download and install reporting server add on ( SharePointRS.msi) following link may be used for downloading SQL Server Add-on from Microsoft site. http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en Now even if you installed the addon it will deploy necessary cab files in your system but web part will not be activated automatically and you need to run following stsadm command in order to activate and utilize web parts "%Syste...