Exporting an SSRS report by going to report in Excel?
I am working in SSRS for generating summary reports. There is a report that uses jump to submit as a navigation parameter. The report works fine on report server, but when exporting to excel the links don't work.
I think when the ssrs report is exported to an excel file, it is exported with hyperlinks that point to the report server.
What I am trying to do is get a hint to inform the navigation functionality between reports.
for example, suppose I have a report named Users that lists some users, and when a username is clicked, the report navigates to another report (User_details) with More Information. This works great with report server. But when I export both reports to excel sheets. The same navigation behavior is not present and I receive 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?
early.
source to share
URL to view reports:
http://[instance_name]/ReportServer/Pages/ReportViewer.aspx/[ReportPath]
Please check manually if this link to your drilldown report is available, maybe you are missing some permissions? Taking a look at your situation, everything should work fine.
UPDATED: If you want to add navigation to excel (no report server), you can change drill link to return drill report excel file. You can add drill-down to your report details - an additional conditional parameter rs: Format:
And also don't forget to include the Omit statement - =Globals!RenderFormat.IsInteractive
this will prevent this extra parameter from being passed interactively (html).
source to share
I created a report similar. What I did was place the sub-report in a tablix textbox in the main report. Then right-click the sub report. In the properties dialog showing, select visibility. Then you want to select "hide" for "When the report first runs". Then check the box next to "Screen can be switched by this report item:". The dropdown should now indicate that you can select the field you want to click so that the auxiliary report data is now displayed.
This is in VS 2012 with SQL Server Reporting Services Developers Version 11.0.3436.0.
source to share