Feed Icon  


  • Bryant Likes
  • Send mail to the author(s) E-mail
  • twitter
  • View Bryant Likes's profile on LinkedIn
  • del.icio.us
Get Microsoft Silverlight
by clicking "Install Microsoft Silverlight" you accept the
Silverlight license agreement

Hosting By

Hot Topics


Open Source Projects



Reporting Services WebParts - Walkthrough

Posted in Reporting Services | SharePoint at Thursday, May 27, 2004 9:40 AM Pacific Daylight Time

In this article I'm going to walk you through how to setup the RsWebParts with SharePoint. The first thing you will need to do is download the CAB file from the RsWebParts workspace. The current version is Next you will need to install the CAB file on your SharePoint server. NOTE: please test these on a development box first. Below are the step-by-step instructions to install the WebParts.

1) Save the CAB file to your SharePoint server in a place that is easy to find (I use c:\temp).

2) On the server, open a command prompt. If you haven't added the STSADM tool to your path environment variable, then you will need to navigate to [c]:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN in the command window (by using >cd program files, >cd common files, etc).

3) At the command prompt type stsadm -o addwppack -filename c:\temp\bml.rswebparts.setup.cab (changing c:\temp\ to the directory where you saved the cab file).

4) You should get a message telling you the wppack was successfully installed.

The next step is to start adding the parts to a page and then connecting them together. To do this you will need a WebPartPage in SharePoint. In the site menu click the create button and scroll down to the WebPartPage option. Create a new WebPartPage. I would suggest the layout that has three zones: header, left column, body. Now you can start adding the parts to your page.

You have a few options for how to put the parts on the page (they are under the Virtual Server Gallery). I would suggest starting with the RsExplorer WebPart since it allows you to explore all the folders and reports on your report server. But you can also start with the RsFolder view, which allows you to browse all the reports in a single folder, or the RsStaticReportView, which connects to a single report. You should use one of these three webparts on your page (note: you can use the other webparts without these, but it makes it more difficult to change the report).

Once you have one of these on the page you will need to set some properties to allow it to work. On the RsExplorer you will need to set the Server URL and the Folder Path. To do this click the down arrow on the RsExplorer WebPart and select Modify Shared Web Part (see image below).


In the Server Url box put the URL to your report server. For example, if your server was named ReportServerA then you would set this URL to http://reportservera/reportserver. The Folder Path is just the root path where the explorer will start at. The RsFolderView and RsStaticReportView have similar properties (FolderPath and ReportPath) which do the same thing. Once you click OK the WebPart should load up the list of reports and you should be able to browse around your report server.

The next step is to add some of the other RsWebParts. You can add the RsReportView (for viewing reports), RsReportExport (for exporting reports), RsReportInfo (for getting report details), and RsParameters (for setting report parameters). After you added these items to the page you will need to setup their connections before you can start using them. The steps to make these connections are outlined below.

1) Put the page into design mode by clicking the dropdown at the top and selecting design this page (see image below).

2) Click the down arrow on the Rs Report View web part and under connections select Connections, Consumes a row from, Rs Explorer (see image below). This connetion is what sets the report that the viewer will display.

3) Click the same down arrow on Rs Report View but this time choose Consumes a row from Rs Report Parameters. This connection determines what parameters the report will use to render the report.

4) Click the same down arrow once more, but this choose Provides a cell to and select Rs Report Export. This provides the Url that the viewer is currently using so that the export webpart can export it.

5) Click the down arrow on the Rs Report Parameters and select Connections, Consumes a row from, and select Rs Explorer. This allows the parameters to get the right parameters based on the report you've selected.

6) Finally click the down arrow on the Rs Report Info and select Connections, Consumes a row from, and select Rs Explorer. This allows the web part to display the report information.

You should now be able to select a report and have all the other parts display the correct information. Changing the parameter should change the report. You should also be able to export the report using the export webpart.

I hope you like the web parts! If you find bugs please report them on the workspace and if you would like to add features to the project please apply to join the workspace.


Tuesday, June 8, 2004 4:22:00 AM (Pacific Daylight Time, UTC-07:00)
I got this baby to work! Many thanks for putting it together.
Wednesday, June 9, 2004 12:54:00 AM (Pacific Daylight Time, UTC-07:00)
Grate! We are looking forward to use this solutions sone.
Tuesday, June 15, 2004 5:54:00 AM (Pacific Daylight Time, UTC-07:00)
I have reports that Use Date Parameters. I am getting a sType Undefined Error When I try to uyse the Report Parameters
Wednesday, June 16, 2004 1:54:00 AM (Pacific Daylight Time, UTC-07:00)
I will have to look into that error. I thought it was working with Date parameters but I could be wrong.
Saturday, June 19, 2004 4:18:00 PM (Pacific Daylight Time, UTC-07:00)
I'm getting the error on 1 server.
<br>microsoft vbscript runtime error
<br>object required: creationdate()
<br>line is offset from the start of the script block.
<br>and on the second server i'm getting this error
<br>Server did not recognize the value of HTTPheader SOAP action http:\\schemas.microsoft.com\sqlserver\2003\12\reporting\reportingservices\listchildren.
<br>Any help is appreciated.
Valter Borges
Saturday, June 19, 2004 4:34:00 PM (Pacific Daylight Time, UTC-07:00)
Report Viewer works but export when consumming a report and using one sharepoint server which is pointing at a report on reporting services on a different server does not work it opens up the url incorrectly.
<br>Any help is appreciate.
Valter Borges
Tuesday, June 22, 2004 11:34:00 PM (Pacific Daylight Time, UTC-07:00)
<br>Can you send me an email with more information or post a bug report to the workspace?
Wednesday, June 23, 2004 6:29:00 AM (Pacific Daylight Time, UTC-07:00)
<br>I downloaded the cab file and saved it to c:\Temp folder on the server. Ran through your instructions and hit an error when I tried to run stsadm.
<br>Unknown arguement: c:\temp\bml.rswebparts.setup.cab
<br>Not sure what I am doing wrong. Any help would be appreciated!
<br>thank you in advance.
Wednesday, June 23, 2004 6:49:00 AM (Pacific Daylight Time, UTC-07:00)
Sounds like you forgot the -filename argument. Can you post what you're typing at the command line?
Wednesday, June 23, 2004 10:47:00 AM (Pacific Daylight Time, UTC-07:00)
I got the same error as Valter Borges
<br>Please Help!
<br>microsoft vbscript runtime error
<br>object required: creationdate()
<br>line is offset from the start of the script block.
Bo Dong (bo_dong@yahoo.com)
Thursday, June 24, 2004 10:26:00 AM (Pacific Daylight Time, UTC-07:00)
Fantastic work. All functionality appears to be working well.
<br>However two issues I've come across.
<br>1. Using the explorer web part - pops up a message whenever it is rendered about security (yes/no to continue)
<br>2. I really just need the report view, however the report does not update once it has been assigned, I have changed data as well as report layout and neither are reflected when I reload the web part page. The report is set not to cache and the updates are shown when viewed directly via the url
Friday, June 25, 2004 12:11:00 AM (Pacific Daylight Time, UTC-07:00)
Glad you like it. The security error is something you can't really get around unless you put the reporting service in the intranet zone and turn off prompting for that zone.
<br>The updating issue is interesting. I haven't seen this issue. Since the viewer is really an iframe it shouldn't be caching things any more than the regular browser. I will look into adding a refresh button but for now you can probably right click the report and select refresh to refresh the report.
Sunday, June 27, 2004 10:23:00 AM (Pacific Daylight Time, UTC-07:00)
I have had a play with the refresh issue. I embedded the report in a standard 'Page View' web part and the same effect is seen. The report does refresh when the Reporting Services refresh button is pressed, but not when a IE refresh is done (right click, etc). So I think that where there is a report with dynamic data the Reporting Services refresh mechanism will be essential. A button would be good, but even better would be a property that would allow enabling an 'auto refresh on load' - which would refresh the report whenever the report is rendered - a nice feature for highly dynamic reports.
Sunday, June 27, 2004 10:19:00 PM (Pacific Daylight Time, UTC-07:00)
That did it! Thank you!!!
Monday, June 28, 2004 5:57:00 PM (Pacific Daylight Time, UTC-07:00)
i tried reporting web part but is not give me any listing of reports
Monday, June 28, 2004 11:04:00 PM (Pacific Daylight Time, UTC-07:00)
Make sure you set the report server URL correctly and that you have reports on your server.
Tuesday, July 6, 2004 8:53:00 PM (Pacific Daylight Time, UTC-07:00)
<br>Very nice job !!!
<br>After changed the rs.js ('type' insted of 'sType') due to rs parameter problem all work fine.
Wednesday, July 7, 2004 4:57:00 AM (Pacific Daylight Time, UTC-07:00)
Awesome, wonderful stuff. Is it possible to hide the "Reporting Services Error" message that apears before a report and parameters are selected?
<br>Take care,
Tuesday, July 13, 2004 5:47:00 PM (Pacific Daylight Time, UTC-07:00)
My system is Windows 2003, I can not find the root "[c]:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN", My root is "[c]:\Program Files\Common Files\Microsoft Shared\web server extensions\40\BIN and [c]:\Program Files\Common Files\Microsoft Shared\web server extensions\50\BIN ", at the same time ,can not find "stsadm"
Wednesday, July 21, 2004 8:40:00 PM (Pacific Daylight Time, UTC-07:00)
it is very nice webpart
<br>but i have no idea to first step
<br>my server name is
<br>so i put
<br><a target="_new" href="http://swdevsrv0/reportserver">http://swdevsrv0/reportserver</a>
<br>then in folder path what information i put
<br> please tell to me ) i didn understand what the line say
<br>'The Folder Path is just the root path where the explorer will start at. The RsFolderView and RsStaticReportView have similar properties (FolderPath and ReportPath) which do the same thing.
Wednesday, July 21, 2004 9:20:00 PM (Pacific Daylight Time, UTC-07:00)
Has anyone managed to use the RS Static Report View?
<br>All other web parts run ok but this.
<br>In the parameters I have:
<br>Server URL: <a target="_new" href="http://bagr-ath-fs17/reportserver">http://bagr-ath-fs17/reportserver</a>
<br>Report Path: /1- Ex Warehouse Sales/1-1 PH ExWarehouse Sales/1-1-4 Ex Warehouse Monthly Sales Product
<br>Any ideas?
Thursday, July 22, 2004 1:04:00 AM (Pacific Daylight Time, UTC-07:00)
Are you getting an error? The static view doesn't have any visible results. It only allows you to connect multiple webparts to the same report.
Thursday, July 22, 2004 1:16:00 AM (Pacific Daylight Time, UTC-07:00)
Felix: Just put a "/" without the quotes for the root folder. Other folders would be /[folder name]. If you need to map to a specific report you would use /[folder name]/[report name].
Friday, July 23, 2004 6:14:00 AM (Pacific Daylight Time, UTC-07:00)
First of all - great job with the webparts.
<br>I am able to connect to SRS directly from RS Explorer. However, I am trying to create a simple webpart view by just using the RSreportViewer and RS Report Paramaters. Each of them is connected to the ReportServer however when I try to connetc them both, I get "..... Error: 'sType' is undefined"
<br>Any idea on what could be wrong?
Monday, July 26, 2004 4:17:00 AM (Pacific Daylight Time, UTC-07:00)
The sType error is a bug that can be fixed by replacing sType with type in the rs.js file as mentioned here:
<br><a target="_new" href="http://blogs.sqlxml.org/bryantlikes/articles/628.aspx#781">http://blogs.sqlxml.org/bryantlikes/articles/628.aspx#781</a>
Thursday, August 5, 2004 11:51:00 PM (Pacific Daylight Time, UTC-07:00)
Is it possible to get the reports from a different server from the server sps is on?
Monday, August 9, 2004 12:58:00 AM (Pacific Daylight Time, UTC-07:00)
Veyr nice, however I still could not get the rsparameters web part to work. I already changed the rs.js file.
Tuesday, August 24, 2004 5:48:00 AM (Pacific Daylight Time, UTC-07:00)
Thanks for great web parts.
<br>Only issue I am having is with rsparameters web part.
<br>Even after replacing the "sType" with "type" in rs.js, still it is giving sType error.
Tuesday, August 24, 2004 7:06:00 AM (Pacific Daylight Time, UTC-07:00)
sType Problem gone. Try this:
<br>1. Change the sType to type in rs.js.
<br>2. Clear the temp files.
<br>3. Open the reports.
<br>Great job Bryant!
Wednesday, August 25, 2004 8:34:00 PM (Pacific Daylight Time, UTC-07:00)
Nice web parts really helpful.
<br>One thing in the RS Explorer I get all the web parts I can run not all the web parts I can view. So I have sub reports that are run by other reports that can't be run on thier own. So when I browse from sharepoint I get many more reports.
<br>Hope that made sense.
<br>Thanks again and comments appreciated.
Thursday, August 26, 2004 7:33:00 PM (Pacific Daylight Time, UTC-07:00)
Can sb. tell me where is this rs.js file located?
Thursday, August 26, 2004 7:48:00 PM (Pacific Daylight Time, UTC-07:00)
I have found it and fixed the problem. It works now. But there is a new issue popped up. In some of the reports, I have used dynamic parameters (with pull down menu), which now in the RS Report Parameters Web Part are with no more pull down menus. Could you please look into this problem and fix this bug? Thanks a lot in advance.
<br>Anyway, they are really fantastic web parts.
Saturday, August 28, 2004 8:24:00 PM (Pacific Daylight Time, UTC-07:00)
thanks for these - are very useful.
<br>One thing though - can't seem to get the Static Report viewer to work.
<br>Maybe, I'm being dumb, but not sure exactly what setting to put for server URL, and report path.
<br>For example, the report I'm trying to use has the following hyperlink:
<br><a target="_new" href="http://MYSERVER/Reports/Pages/Report.aspx?ItemPath=%2fSamples%2fCompany+Sales">http://MYSERVER/Reports/Pages/Report.aspx?ItemPath=%2fSamples%2fCompany+Sales</a>
<br>Also, I get a "security risk" warning from IE each time I use a page with one of the web parts - something about the page not being under the control of the site.
Monday, September 6, 2004 1:48:00 PM (Pacific Daylight Time, UTC-07:00)
hi.. I am getting this error after entering the date parameters for a report:
<br>"The value provided for the report parameter 'Report_Parameter_0' is not valid for its type. (rsReportParameterTypeMismatch)".
<br>The date parameters are of type datetime.
<br>Is it because it is expecting a string input instead?
Monday, September 13, 2004 1:40:00 AM (Pacific Daylight Time, UTC-07:00)
Fantastic Job Bryant!
<br>This is an exellent and extremly useful tool that you made.
<br>At this point I'm getting troubles when I'm displaying a multi-page report.
<br>The whole report is rendered inside of the Report View, without the paging functionality that provides MS Reporting Services.
<br>Is it possible that I have a configuration issue?
<br>Thank you!
Santiago Aulestia
Thursday, September 16, 2004 6:59:00 AM (Pacific Daylight Time, UTC-07:00)
Hi Bryant
<br>How can I configure a report using the webparts, that has two parameters, one by URL and the other by selection?
<br>Hey, BTW your web parts have added pizzaz to our intranet site!
Thursday, September 16, 2004 5:09:00 PM (Pacific Daylight Time, UTC-07:00)
I see no solution to the "CreationDate" error mentioned a couple of times above. Does anyone have a resolution to this issue?
William Davidson
Tuesday, September 21, 2004 12:32:00 PM (Pacific Daylight Time, UTC-07:00)
Thanks for the great web parts. They seem to work well.
Wednesday, September 22, 2004 1:25:00 AM (Pacific Daylight Time, UTC-07:00)
I keep getting stype undefined on my reports. The report view part simply says the this report requires a parameter but the report parameters part does not give me any options for parameters??
Wednesday, September 22, 2004 1:31:00 AM (Pacific Daylight Time, UTC-07:00)
Changed the only "stype" to "type" in rs.js but what does above user mena when saying "clear the temp files"?
Wednesday, September 22, 2004 2:09:00 AM (Pacific Daylight Time, UTC-07:00)
Now getting the same 'creationDate(...)' error some are getting above. Did anyone ever get this fixed?
Wednesday, September 29, 2004 3:28:00 AM (Pacific Daylight Time, UTC-07:00)
When I add the web part for RS Explorer or RS Folder View, it is fine until I try to configure it with a URL & folder path. After I put in the URL & folder, then hit apply, I get a permission denied error. I am logged onto the box (RDP) with the administrator account.
<br>I can load RS Report View and configure it with the same URL & path without any errors.
<br>Any ideas?
Wednesday, September 29, 2004 6:22:00 AM (Pacific Daylight Time, UTC-07:00)
I downloaded and went through your Walkthrough with the webparts. So far everything seems to be fine until I try to connect the RSParameters web part to the explorer view. Every time I do this I get an error message saying "The "RsParameters" Web Part appears to be causing a problem" I have to delete the web part just to be able to access the page again.
<br>Also why when I access the Manage Web Part Page do these webparts only say "Error" for the web part title. And "ErrorWebPart" for the Type? Should they say something else?
<br>I would appreciate any help as being able to use these would be a big benefit.
Wednesday, October 6, 2004 3:07:00 PM (Pacific Daylight Time, UTC-07:00)
Inspite of changing stype to type : it gives me type undefined
<br>Can any one help ?
Amarnath Solai
Tuesday, October 12, 2004 8:14:00 AM (Pacific Daylight Time, UTC-07:00)
Can you explain what are these web parts doing exactly?
<br>I installed them without any problems but what am I going to do with them???
<br>Could you be more explicit what info should we put in the "Server URL" and "Folder Path" text boxes?
<br>Let's say my server name is: SERVER
<br>No disrespect, and I am sure you spent a lot of time for this web part, but what's the purpose?
<br>We need some documentation!!!
<br>Thank you!
Wednesday, October 20, 2004 12:29:00 PM (Pacific Daylight Time, UTC-07:00)
Ok, so this is all cool...
<br>Can I use internal data from sharepoint (ie. Lists) to generate these reports, and then... can I export the generated reports back into the document repositories inside sharepoint? Even better is that I want them to get data from child-sites of the main one where the control is running and I also need to store the reports in the areas where the data came from.
<br>I could run the control locally in the individual child sites, but I need data from the main site as well....
<br>...I think it's time to cut losses and write this baby in PHP.
Steven Hoefel
Monday, October 25, 2004 8:56:00 AM (Pacific Daylight Time, UTC-07:00)
<br>I'm having a hard time getting the report viewer webpart to render the reports.
<br>nothing happens all the otehr webparts point to the proper locations and items as per your instructions, no error is thrown.
<br>another question:
<br>Would it be possible to get the actual C# code for these Webparts as I need to add another layer of security to them to meet the Business requirements of security for report viewing , that falls outside the scope of the security that sharepoint has built in.
Monday, October 25, 2004 9:54:00 AM (Pacific Daylight Time, UTC-07:00)
First off thanks... The tool works great... It will definately come in handy for me...
<br>I am using the Beta version and had an oddity where The viewer would only work if the Reports were in a subdirectory... off the Root they didnt? So I just put everything in a sub directory and all is good. ;)
<br>Thank you
Jason Rossi
Monday, November 1, 2004 7:44:00 AM (Pacific Standard Time, UTC-08:00)
the Report Viewer Webpart will actually connect but how do you get it to show charts and graphs?
Tuesday, November 2, 2004 9:39:00 PM (Pacific Standard Time, UTC-08:00)
<br>first ..... a good approach !
<br>I have donwloaded and successfully installed the webparts. After walking through your desciption how to set up the webparts I am facing a problem. I have started to add the RSExplorer and pointed to my reportserver. After refreshing the page the webpart area is still empty. No reports are isplayed (but there ARE reports in the pointed folder of the report server !).
<br>Anything I have missconfigured ?
<br>The reportserver is running on another server !!
<br>Thanks for help
Martin Schlenker
Thursday, November 18, 2004 3:12:00 AM (Pacific Standard Time, UTC-08:00)
<br>Great tool. I've been using it for a few months and the users love it. I installed the Beta version to try to resolve the parameters issue I was having, but I'm still running into issues when I use a drop-down list of parameters.
<br>As soon as a value is selected, the report does not generate and no error message is returned. (However, it does work fine when the parameter is not validated against a list.)
<br>Any ideas?
<br>Thanks again for these parts.
Thursday, November 18, 2004 6:27:00 AM (Pacific Standard Time, UTC-08:00)
I want to play with the new webparts too but i'm not a programmer and alot of the stuff up there is gobblydygook to me. :|
<br> I am a competant windows user though and can get around server 2003, Office 2003 and XP Pro for the most part.
<br>In Frontpage 2003 there's an "Import webpart" function when I open the site live. Can't I just do it that way without going through all the other junk?
Friday, November 19, 2004 12:17:00 AM (Pacific Standard Time, UTC-08:00)
I have added a RS exployer part to my page and set the server url. but all I see is "Retreiving Data....."
<br>Any help?
<br>Shawn McFArland
shawn McFarland
Thursday, November 25, 2004 6:11:00 PM (Pacific Standard Time, UTC-08:00)
I have deployed the web part in my share point server. But I am getting error, when I set the url for the Server URL for Rs Explorer. I am getting Access denied error.
<br>My sharepoint is on windows 2003 server and my reporting service server is in win2k professional.
<br>eg: share point admin address : <a target="_new" href="https://subin:8098/default.aspx">https://subin:8098/default.aspx</a>
<br>and reporting service address : <a target="_new" href="http://arihantjain/Reports/Pages/Folder.aspx">http://arihantjain/Reports/Pages/Folder.aspx</a>
<br>Any help?
Thursday, December 9, 2004 2:44:00 PM (Pacific Standard Time, UTC-08:00)
I have changing "stype" to "type" in the file rs.js but it gives me:" type undefined "
<br>Can any one help ?
Monday, December 13, 2004 3:53:00 AM (Pacific Standard Time, UTC-08:00)
<br>I'm getting the same results as 11/19/2004 8:17 AM by Shawn McFarland . Have you found a solution?
<br>I'm tried the following five [URL - Folder] combinations:
<br>[<a target="_new" href="http://dwdev.mercurycompanies.com/ReportServer">http://dwdev.mercurycompanies.com/ReportServer</a> - /Reports/Pages/Folder.aspx?ItemPath=%2fSalesReps&IsDetailsView=False]
<br>[<a target="_new" href="http://dwdev.mercurycompanies.com/Reports">http://dwdev.mercurycompanies.com/Reports</a> - /Pages/Folder.aspx?ItemPath=%2fSalesReps&IsDetailsView=False]
<br>(This I thought should work since it is the FQDN to the reports)
<br>[<a target="_new" href="<a target="_new" href="http://dwdev.mydomain.com">http://dwdev.mydomain.com</a>/ReportServer"><a target="_new" href="http://dwdev.mydomain.com">http://dwdev.mydomain.com</a>/ReportServer</a> - /Reports]
<br>[<a target="_new" href="http://dwdev.mydomain.com">http://dwdev.mydomain.com</a> - /Reports]
<br>[<a target="_new" href="http://dwdev.mydomain.com">http://dwdev.mydomain.com</a>/Reports - blank Folder option]
<br>With the blank folder option WSS errors with:
<br>The "RsExplorer" Web Part appears to be causing a problem.
<br>Web Parts Maintenance Page: If you have permission, you can use this page to temporarily disable Web Parts or remove personal settings. For more information, contact your site administrator.
<br>None of it works. Plus I'm always getting an Access Denied pop-up box after clicking Apply or OK.
<br>The WSS server and SQL RS Report Manager are on the same box server.
<br>The WSS server URL is <a target="_new" href="http://intradev.mydomain.com">http://intradev.mydomain.com</a>
<br>The SQL RS Manager URL is <a target="_new" href="http://dwdev.mydomain.com">http://dwdev.mydomain.com</a>/Reports and is on the Default web site.
<br>I've used Host Headers and DNS CNAME (aliases) for reference the server name for each web site FQDN.
<br>Server is Windows 2003 Web Ed w/ WSS 2.0 and RS SP1 Standard.
Monday, December 13, 2004 4:05:00 AM (Pacific Standard Time, UTC-08:00)
Another thought...
<br>I'm thinking that the people who have got it to work are using the Default web site for both WSS and RS. That way credentials are passed within the same application pool web site context. I'm going to try and setup/move the Reports and ReportServer virtual folders to the WSS web site I expanded and created separately from the Default web site. Here is the article to move the RS folders. <a target="_new" href="http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk">http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk</a>. We'll see...
Monday, December 13, 2004 8:05:00 AM (Pacific Standard Time, UTC-08:00)
Well... the last steps didn't work. Still getting "Retrieving data... " displayed on RS Explorer web part.
<br>I tried a number of combiniations for the URL and Folder after getting RS and WSS side-by-side on a different web site. Followed the steps below:
<br>Move RS to different Web Site
<br><a target="_new" href="http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk">http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk</a>
<br>WSS and RS side-by-side
<br><a target="_new" href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp</a>
Monday, December 13, 2004 8:13:00 AM (Pacific Standard Time, UTC-08:00)
I got it working... With WSS and RS on same server/web site other than default web site.
<br>URL: <a target="_new" href="http://dwdev.mydomain.com/ReportServer">http://dwdev.mydomain.com/ReportServer</a>
<br>Folder: /SalesReps
<br>Follow the steps in Bryant's Article after Performing the steps outlined here:
<br>Move RS to different Web Site
<br><a target="_new" href="http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk">http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk</a>
<br>WSS and RS side-by-side
<br><a target="_new" href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp</a>
Tuesday, January 11, 2005 3:01:00 AM (Pacific Standard Time, UTC-08:00)
Hi Bryant,
<br>First of all, i'd like to congratulate you for this great webpart..!!
<br>I'm having an error with parameters. With the reports that doesn't have parameters works excelent. But with reports with parameters shows the followin error:
<br>Cannot read reports from the server.
<br>Please check the path to the web-service and folder. Error: Object required.
<br>Can you help me, please.
Tuesday, January 11, 2005 3:43:00 AM (Pacific Standard Time, UTC-08:00)
So if Sharepoint and Rs are installed on differnt servers ,it means that I can't use RS Explorer?? Somebody please help me .I can't get it working ,RS explorer keeps on showing "Retrieving data..." and it never shows reports.
Tuesday, January 11, 2005 3:47:00 AM (Pacific Standard Time, UTC-08:00)
I forgot to say that ,I got the following error when I installed the web part on my Sharepoint Portal server:
<br>====WPPackager install log started 1/11/2005 10:31:42 AM =========
<br>1/11/2005 10:36:12 AM: Error: Config file: 'c:\inetpub\wwwroot\web.config' for virtual server '<a target="_new" href="<a target="_new" href="http://my_sharepoint_server/">http://my_sharepoint_server/</a>"><a target="_new" href="http://my_sharepoint_server/">http://my_sharepoint_server/</a></a>' is missing or appears invalid. Could not apply required CAS settings to this server.
<br>1/11/2005 10:36:12 AM: Error: Could not apply required CAS settings to virtual server '<a target="_new" href="<a target="_new" href="http://my_sharepoint_server/">http://my_sharepoint_server/</a>"><a target="_new" href="http://my_sharepoint_server/">http://my_sharepoint_server/</a></a>' during installation of 'RsWebParts'
<br>1/11/2005 10:36:13 AM: Success: Installation Successfully Completed
<br>You have successfully installed this package.
<br>Note: After you configure the virtual server, you must restart Internet Information Services (IIS), by typing iisreset on the command line.
Wednesday, January 12, 2005 2:48:00 AM (Pacific Standard Time, UTC-08:00)
Here is how I got it to work. When you put in the name of the url for the server, I used <a target="_new" href="Http://servername/reportserver">Http://servername/reportserver</a>, instead of <a target="_new" href="http://servername/reports">http://servername/reports</a>, which is the web portion of the reporting server.
<br>If you were to type <a target="_new" href="http://servername/reports">http://servername/reports</a>erver into a browser, you should get a directory structure, which is what I beleive the webpart wants to read.
<br>As for the stype error, if you change the rs.js file as mentioned in an above posts, and delete you temporary internet files, that should work aslo.
Brandon A.
Thursday, January 13, 2005 8:24:00 AM (Pacific Standard Time, UTC-08:00)
Ofcourse you must use "<a target="_new" href="Http://servername/reportserver"">Http://servername/reportserver"</a> and u can never use Report Manager to get service from RS.Do u have RS and WSS on the same server??if yes Are they on the same virtual directory???
Sunday, January 23, 2005 6:16:00 PM (Pacific Standard Time, UTC-08:00)
I have a report with 2 parameters.. the second parameter is dependent on the first parameter.. I have noticed that when I changed the first parameter, the values of the second parameter doesn't changed.., so I got an error..
<br>any help?
Thursday, January 27, 2005 12:07:00 AM (Pacific Standard Time, UTC-08:00)
I can't seem to download the cab file. It keeps sending me to the GotDotNet workspace website. Please help.
Thursday, February 3, 2005 5:57:00 AM (Pacific Standard Time, UTC-08:00)
It is great that you have provided this webpart. Following your steps from above everything seems to be fine until I try to generate the report. Down by the RS Report View I get this error.
<br>"This report requires a default or user-defined value for the report parameter 'Database'. To run or subscribe to this report, you must provide a parameter value."
<br>With just reporting services Report page I can run this parameter fine. NOt sure why there are no parameters for me to run with the Web Part. Just a side note, the Database parameter is a static one. NOt sure if that has anything to do with it.
Thursday, February 3, 2005 6:00:00 PM (Pacific Standard Time, UTC-08:00)
RSWEBPARTS work fine when the report has no dependent parameters.. But when it has a dependent parameters, I'm having an error.. when I changed the first parameter, the values of the second parameter doesn't changed...
Monday, February 7, 2005 3:51:00 PM (Pacific Standard Time, UTC-08:00)
hello.. about the parameter issues., the parameter dependencies, when will it be fixed? thanks 4 reply...
Friday, February 11, 2005 2:07:00 AM (Pacific Standard Time, UTC-08:00)
im trying to figure out how to refresh reports on load beside of behing forced to push the refresh button every times.. anyone found a way to do it?
Ibm developpers
Monday, February 14, 2005 12:53:00 AM (Pacific Standard Time, UTC-08:00)
<br>I am using Stored Procs to get my data, the SP's for instance contain 3 parameters, 2 that i want to prompt for and one I want to set dynamically, by sending the value via the url or by changing the default value of this last parameter.
martin - g
Monday, February 14, 2005 12:58:00 AM (Pacific Standard Time, UTC-08:00)
<br>I hope someone can help, I have one reporting portal with a set of reports, but many datasources that contains the same data. example, a database per store, so when a user logs in I now to what database he should log into, so i want to change the Datasource dynamically so the report points to the correct database.
martin - g
Monday, February 14, 2005 5:54:00 AM (Pacific Standard Time, UTC-08:00)
<br>Thanks for these webparts and many of the above responses. Kudos on the webparts and the blogs have made configuring them a snap.
<br>When I enter a numeric parameter and <tab> the page refreshes with the default parameter. The second time I enter the parameter and <tab> the page refreshes correctly. Does anyone have a clue why this is happening?
<br>Thanks ahead!
Thursday, March 3, 2005 9:03:00 AM (Pacific Standard Time, UTC-08:00)
<br> I' m new 2 reporting services. Plese help me out in this problem. I have a report which run a SP to get data from DB. That SP takes a parameter. What I want is insted of maintaining static data for that parameter I want to get all parameters values from DB dynamically.
<br> It's plain MS reporting service. There is no backend code.....
<br>Thanks in advance :)
Tuesday, March 8, 2005 11:07:00 PM (Pacific Standard Time, UTC-08:00)
i've got a question concerning the parameter webpart.
<br>Is there a way not to refresh the report everytime i change a parameter.
<br>The reason why I'm asking, ist that i use reports with up to 10 parameters, and its a bit boring to refresh the report 10 times until i get the final config.
<br>is there a way to first set the parameters and then tell him to update the report`?
<br>i already downloaded the source, but i'm not that incorporated in the webpart development....
<br>thanks for help in advance
Monday, March 14, 2005 7:50:00 PM (Pacific Standard Time, UTC-08:00)
i've got a question concerning the parameter webpart.
<br>how to obtain the Sharepoint logged-in userid/username
<br>in the parameter webpart.
Shankar J
Monday, March 14, 2005 8:23:00 PM (Pacific Standard Time, UTC-08:00)
hello ,
<br>i am not getting the reports consistently in the
<br>report viewer webpart.sometimes i get and sometimes
<br>i do not get even though i don't make any changes
<br>can anyone help me
<br>Thanks in advance
Sunday, April 3, 2005 5:58:00 PM (Pacific Daylight Time, UTC-07:00)
Nice work on the web part =)
<br>but I have some concerns,
<br>my report has mulitple parameters, and changing a single parameter causes the report to generate without the other paramters,
<br>is there a way to have a Button, just like the "View Report" button on the default toolbar of the Report Viewer?
<br>thanks =)
Tuesday, April 19, 2005 2:52:00 PM (Pacific Daylight Time, UTC-07:00)
I have a question concerning the RS Report Export webpart.What are the API's used in the reporting services to obtain the functionality of this webpart???
<br>thanks in advance
Wednesday, April 20, 2005 2:21:00 AM (Pacific Daylight Time, UTC-07:00)
It is using the URL access API. See the RS documentation for more information.
Friday, June 3, 2005 2:07:00 AM (Pacific Daylight Time, UTC-07:00)
rs:ClearSession=True in the query string to open reports refreshes the report each time it is loaded
Refresh report
Sunday, April 30, 2006 11:07:11 AM (Pacific Daylight Time, UTC-07:00)

for anyone interested - the 'CreationDate(...)' problem is caused by a piece of code within RSExplorer.xsl:

<msxsl:script language="VBScript" implements-prefix="vb">
Function isNew(creationDate)

Dim s, d
s = CStr(creationDate(0).text)

d = CDate(Left(s, 10))

isNew = DateDiff("d", d, Date) <= 3

End Function

In some scenarios, this code is failing either because a) creation date is empty or b) some other problem that i havent been able to diagnose (due to time).

If you want a quick fix, just remove all references to that function within RsExplorer.xsl (there's 2 references, where it displays a new.jpg)

HTH someone else,

Matthew Cosier
Wednesday, May 3, 2006 6:32:27 AM (Pacific Daylight Time, UTC-07:00)
Hi there,

LOVE the webparts. Having a bit of a problem connecting them. The RSEXPLORER isn't passing parameters through the connection properly.
RSexplorer is configured as follows:
server url: http://mydomain.com/reportserver
folder path: /

when i connect it to the RSReportView the RsReportView has the right server, but the wrong Report Path. It receives [//ReportName] instead of [/Reportname].

If i populate the RsReportView manually, it works.

Something about the code? or my config of the rsExplorer?


Fahim Kanji.
Wednesday, June 21, 2006 4:22:04 PM (Pacific Daylight Time, UTC-07:00)
My reports web part page is in the shared documents.I cannot figure out your first step.
I have set the Server Url to http://dev.in.sas.com which is the Intranet WSS Sharepoint site.
Then for the folder path I have set the rest of the url path
Please help me with this.
My email :shubhra.saxena@sas.com
Sunday, August 6, 2006 7:41:40 PM (Pacific Daylight Time, UTC-07:00)
Does anybody knows how to display the Report toolbar in a report generated by a SOAP call to the reportserver using ASP.NET?
Monday, August 28, 2006 8:29:34 PM (Pacific Daylight Time, UTC-07:00)

It's a good work ! that's great (y)

But I have a problem in RS Webparts, when I want to integrate "RS Explorer" in my page, I give the URL server : "http://srv-sps/Reports" and Path : "/"
but he displays all the time : "Retrieving Data".

And when I integrate "View Report", he displays the folder of reports but he doesn't display the reports, just the folder, I don't know why.

Can you help me .

Tuesday, September 5, 2006 1:31:04 AM (Pacific Daylight Time, UTC-07:00)
Thank you so much for these this walkthrough. After beeting SharePoint 2007 B2 with an ugly stick I managed to get these working per your exact instructions. Yes the CAB works and installs ok using the stsadm commandline exactly as mentioned above. The Web Parts do show up in the available list to use and drop in for SPS 2007.

Tuesday, November 28, 2006 2:59:15 AM (Pacific Standard Time, UTC-08:00)
Ok. (Me again) I've pulled back our Sharepoint to 2003, and I'm having trouble putting multiple RSReportViewer web parts one one page. It's almost as if they lock and neither report will show. One works by itself on the page. Can you have two one sharepoint page?

As a workaround I can easily throw a ASP.NET gridview together for a minor report to "look like" another SRS report, but I'd rather keep them together off of the same development platform.

Monday, January 22, 2007 4:06:20 AM (Pacific Standard Time, UTC-08:00)
I just installed a fresh lab machine with WSS 3.0 and SQL 2005 SP1. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Joe S
Thursday, February 8, 2007 6:29:57 AM (Pacific Standard Time, UTC-08:00)
I need to send the values from a list inside a report.
That is the Datasource would be a list rather than a SQL request.
Does your tool allow me to do that ?

Nice Work !
Wednesday, March 7, 2007 11:56:54 PM (Pacific Standard Time, UTC-08:00)
Hello, Bryant.
You really has done a very good work ...

But I have a doubt with the RS Report Parameters WebPart...

If I have for exmaple two combo parameters...
And I select a value in the first parameter...
and values to select (options to choose) in the second parameter depens on the first parameter's value,
how can I obtain that these values of the second parameters are "refreshed" depending on the value selected in the first parameter???

Thank you in advance,

Oscar Daimiel
Sunday, July 15, 2007 8:33:05 PM (Pacific Daylight Time, UTC-07:00)
I have the reportserver on a different box to SharePoint. I've downloaded and installed the webparts on the sharepoint server but when I add the Parameter web part I get this:
"cannot read reports from the server. Please check the path to the web services and folder Error: 'SType' is undefined"

Questions are:
1. Where is the rs.js file located to change sType to type as described above? SharePoint Service c:\.....?
2. How do I clear the temp files?

Thanks a lot,
Sunday, July 15, 2007 9:05:16 PM (Pacific Daylight Time, UTC-07:00)
Just to let people know I have got the previous thread no working. Here is a more detailed description for people who get stuck with the sType issue:
"cannot read reports from the server. Please check the path to the web services and folder Error: 'SType' is undefined"

1. Go to the server where SharePoint is installed.
2. Look for the rs.js file (mine was located: d:\seb sites\Intranet\WPRESOURCES\BML.RSWebParts)
3. Search for sType in the rs.js file.
4. change sType to type - CASE is important all lower.
5. Now go to your IE page: Tools -> internet Options -> Delete Files...
6. Go to the SharePoint site through IE and your parameters should now appear.

Hope this helps.

Tuesday, September 25, 2007 2:29:21 AM (Pacific Daylight Time, UTC-07:00)
Would you know where I can find a version of RSWebparts.cab that has the Report Parameters webpart? The RSWebparts.cab files I have seen thus far only have the Report Explorer and the Report Viewer WebParts.
Monday, December 10, 2007 11:49:22 PM (Pacific Standard Time, UTC-08:00)
where can i find an updated version resolving all above issues.
Gopi Krishna
Tuesday, May 13, 2008 5:31:31 PM (Pacific Daylight Time, UTC-07:00)
hey i want the RSWebparts.cab file can you please tell me from which site i can download it easily?
Tuesday, May 13, 2008 7:45:11 PM (Pacific Daylight Time, UTC-07:00)
hey ,
i need to pass parameters from Sharepoint to SRS dynamically.
can you plz guide me on what i can do for the same ?
and is it possible to do so ?
Monday, September 29, 2008 2:51:45 PM (Pacific Daylight Time, UTC-07:00)
Hi all,

I am working on a project where there is a requirement to integrate SSRS with Sharepoint 2007. Sharepoint lists are to be used as data source. I am getting the data from the list. Now what I have to do is to apply parameters on the list so that I can filter the data by selecting a value from the dropdown within SSRS only. I need to know the syntax/procedure of how to do this and I am not using any Web Part.

Any help will be appreciated.

Comments are closed.