SSRS2008 and Sharepoint2007 .rdl viewing issue
Hi, hopefully someone can offer some advice...Scenario-SSRS2008 running in Sharepoint integrated modeMOSS2007Using SQL Reporting Services Report Viewer Web PartMultiple .rdl files, which link together correctly using Reporting ServicesProblem-We have a starting page (.rdl) which has links referencing all the other .rdl files. All the .rdl files have been uploaded into a single Sharepoint document library.The idea is, we have configured the Web Part to display the start page, then the user can navigate around reports by clicking on each individual report.The start page opens fine in the web part.When we click to view a different report, we get the following: The item 'http://sharepoint-dev1.<domain>/<document library name>/Name Report' cannot be found. (rsItemNotFound) In the .rdl xml file, we use the following to configure how we link to a report:IIF(Fields!Report_Name.Value="Name Report","Name Report"So if a user clicks on the "Name Report" link, it directs them to the "Name Report" report.This configuration works correctly if you view the whole solution in SSRS, but not in MOSS...The problem as I see it, is that I have uploaded each file as "Name Report.rdl", but as you can see in the xml config, the reference is just to "Name Report" without the .rdl extension. Therefore to test, if I amend the url string to'http://sharepoint-dev1.<domain>/<document library name>/Name Report.rdl'it loads the report.So, why does this work in SSRS but not Sharepoint? If I amend eachreport to append the .rdl extension,ieIIF(Fields!Report_Name.Value="Name Report","Name Report.rdl"it works in Sharepoint but then breaks SSRS...I have tried renaming the files before I upload them to take off the .rdl extension, but then Sharepoint doesnt know what kind of file it is.I have also tried using Sharepoint Designer to change the file name once I have uploaded the file, but again Sharepoint doesnt know what kind of file it is and doesnt load the report.Does anyone know how to get round this problem, other than have 2 sets of the same report files, one set that works in SSRS, and one set that works in MOSS.???Many Thanks
March 12th, 2009 7:50am

Hi tjdoc2009, In the Report Server, drilling the sub report through the parent report, cannot include the file extension by design. In the SharePoint ReportViewer webpart, drilling the sub report through the parent report must include the file extension by design. The closest you could get to work around right now is to: 1. Add a new Boolean parameter to the starting report, and set the default value as True. Hide this parameter. We can assume that True means that the reports are in the Report Server, and False means the reports are in SharePoint. 2. Change the expression of DrillThrough to =IIF( (Parameters!parameter.Value = True) AND (Fields!Report_Name.Value="Name Report"), "Name Report", "Name Report.rdl"). The SQL Server Business Intelligence Development Studio or Report Server will search for the sub report Name Report. If in SharePoint, it will look for the sub report Name Report.rdl. 3. Before deploying the reports to SharePoint, change the default value of the Boolean parameter from step 1 to False. If you have any more questions, please feel free to ask. Thanks, JinJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
March 18th, 2009 3:17am

tjdoc (and anyone else with this problem),I had this same issue and found an even simpler solution that doesn't require you to set any parameter values before you deploy (and then change it back so it will work in SSRS).Instead of creating a new parameter value just to include or exclude the .rdl extension, you can make use of the Globals!ReportServerUrl built-in field in your expression editor. When working in SSRS before deployment, this field will have no value, but if you're viewing the reports in Sharepoint, it will be populated. This allows you to do something like this in your drill-down actions:IIF(Globals!ReportServerUrl Like "*http*", "ReportName.rdl", "ReportName")This way, it doesn't matter if you're working on the reports in the developer studio or deploying to Sharepoint. There are no values to change before you deploy and then have to change back after you deploy.-Smitty
October 2nd, 2009 10:57am

Hi Jin,I am doing same thing in my report. Every thing is working for me. Evene when i pass the parameters from parent report to child report. But when i select multiple values in the parameter, then my the redirection fails from parent to child.I am not able identify the cause as this works (passing multiple values) perfectly in BIDS and when report is opened from Report Library. this fails fails only when i open report from Sharepoint integrated mode.My parameter is Geography selection which is hieraarchy created in SSAS cube. Can you please throw some ligh on this.Thanks in advance,Mady
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2009 7:51am

The fact that reportname gives the .rdl extension in Sharepoint and not in Native Mode is actually a good thing. It makes it easy to determine if the .RDL extionsion is needed for the drill-in’s. I spent all day looking for a solution and no where did this suggestion come up but it seems to work well..
June 30th, 2011 3:11pm

Jin Chen, You made my day today !! The drillthrough "iif" experssion worked like magic for me
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2012 3:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics