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.

Comments

Post a Comment

Popular posts from this blog

Sharepoint 2007 Showing outlook Inbox using outlook active X control

Outlook provides active X interface for displaying out look inbox and simple object tag can be used to show emails from your outlook inbox. It will display your default inbox therefore can even show images that are stored at your pst file. You may also use this Active X control in Share point 2007 using content editor web part to display users emails but following disadvantages should be kept in mind. Security concerns as it is Active X control Different browser specific and deployment specific issues Look n feel will be different and cannot be branded Will not use Share point security but will show inbox based on outlook configuration e.g. of HTML is as follows. <OBJECT classid=CLSID:0006F063-0000-0000-C000-000000000046 id=ViewCtlFolder width="100%" height="430" Codebase="http://activex.microsoft.com/activex/controls/office/outlctlx.CAB#ver=9,0,0,3203">> <param name="Namespace" value="MAPI"> <param name="Folder&q
Read more

IIS Configuration Error Error: Cannot write configuration file due to insufficient permissions

While deploying my custom asp.net application I found it hard to browse through few asp.net pages. I tried to enable directory browsing feature to locate pages. Selecting enabled after clicking on directory browsing gaves me following error Error: Cannot write configuration file due to insufficient permissions Looking at above issue I thought that may be I need to start my IIS as an administrator so I closed my IIS and start IIS console again as an administrator but above error remain as is. I decided to go for some research over the internet and found an unbelievable solution. i.e. My web.conf file was readonly :D.
Read more

Grails - Introduction

I would like to give you a little introduction of grails in newbie term. If you have decided to start doing web development or learning web development in java then Grails is for sure an good candidate for you to pick and learn Grails provide the framework based on following 1. Hibernate - ORM layer 2. Groovy Server Pages - Presentation/Web layer 3. Spring - Controller layer Why I started to learn grails has a different reason ;) but would suggest techies to just have a look if you choose to go with Java Web Project and would like to reduce some development time
Read more