I am working in SSRS to generate drill down reports. There is a report which uses the jump to report as a navigation parameter. The report works perfectly on reporting server but when exported to excel the links do not work.
I guess when the ssrs report is exported to excel file it is exported with the hyperlinks which points to the reporting server.
What I am trying to do is get the jump to report navigation functionality between the reports.
for example suppose I have a report named Users which list some users and when the name of the user is clicked the report jumps to the another report (User_details) with additional information. This works fine with the reporting server.
But when I export both the reports into excel sheets. The same navigation behavior is not there and I end up with the following message.
Unable to open http://reortserver/?%2FdrilldownReport2&Region=WW&rs%3AParameterLanguage=. Cannot locate the Internet server or proxy server.
Is there an efficient way to achieve this?
thanks in advance.
Best Answer
The url for report preview buildings as:
Check by hand if this link to your drill down report is available, maybe you are missing some permissions? Looking at your situation, everything should work fine.
UPDATED: If you want to add navigation in excel (without report server) - you can change drill down link to return excel file of drill down report. You can add to your drill down report parameters - additional conditional parameter rs:Format:
And also don't forget to include Omit expression -
=Globals!RenderFormat.IsInteractive
- this will prevent from passing this additional parameter in interactive mode (html).