Wednesday, November 11, 2009

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

"%SystemDrive%\Program Files\Common Files\Microsoft Shared\web server
extensions\12\bin\stsadm.exe" -o addwppack -globalinstall -force -filename
"C:\Program Files\Microsoft SQL Server\90\Tools\Reporting
Services\SharePoint\RSWebParts.cab"

After running above command reporting server web part will be
available in miscellaneous group.

No comments:

Post a Comment