Report drill down links not working after exporting to excel
Hi, We are currently setting up our reports this way. /Master/MainReport.rdl /Master/subReport.rdl /Sales/linktoMainReport.rdl The Sales People do not have acccess to the Master folder but have direct permission to subReport and linktoMainReport.rdl When they run linktoMainReport.rdl and drill down to the subreport in the web base Report Manager it all works fine as it redirects them to /Master/subReport.rdl. When the user exports the report to excel, and tries to drill down. The drill down in excel tries to go to access /Sales/subReport.rdl which of course doesn't exist. Without creating a link to the subReport everytime, is there anyway to fix this?
August 7th, 2011 10:07pm

Hi quacka6, Generally, we can click a link in the main report to access the subreport, which is published to the same report server as the main report, but they can be in different folders. In your scenario, when we try to drill to subreport by clicking the link in linktoMainReport excel file, it is obvious that the linktoMainReport has been considered as main report. So it will search the subreport within the folder containing linktoMainReport on Report Server by default. So, to make it work as you need, we must specify paths in report item properties to reference the subreport that is external to linktoMainReport file and are stored on a report server. · On a report server: The path starts from /, the Home folder. For example, /Reports/AllSubreports/Subreport1. · On a SharePoint site: You must specify the report name in an expression, with the full URL of the item and the file extension .rdl. For example, ="http://server/site/library/folder/Report1.rdl". More information about Specifying Paths to External Items, please see:http://technet.microsoft.com/en-us/library/dd220423.aspx Thanks, LolaPlease remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
August 9th, 2011 4:07am

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

Other recent topics Other recent topics