Last post Jun 27, 2014 08:59 AM by jeeveshfuloria08
Jun 24, 2014 09:57 PM|RajaShekharReddy|LINK
I am working on SSRS 2012. In main report having hyperlink. When click this hyperlink in browser (IE 11 or Chrome), it open sub report correctly. But once i download the main report to Excel 2013 and click hyperlink, it can't open sub report.
I am getting following error message in Excel file. Unable to open "http://...". Cannot download the information you requested.
In SSRS 2005, it is working fine.
How can i fix this issue in SSRS 2012?
Raja Shekhar Reddy
Jun 26, 2014 02:20 AM|Michelle Ge - MSFT|LINK
According to your description, after you download the report into excel, you want to display another report by the hyperlink. So far as I know, you should get the URL address, to check if we we can get the report by the URL address. The address should be:
We should make sure the permissions for the subreport.
There is a similar thread, please refer to the link below:
Hope it's useful for you.
Jun 26, 2014 11:03 PM|RajaShekharReddy|LINK
Thanks for your reply.
Hyperlink url is correct. If I copy that url in browser then sub report is displaying.
In SSRS 2005 these hyperlinks are working in Excel file.
In SSRS2 2012 also download to pdf file and click hyperlinks in pdf file sub report is displaying.
But in Excel and Word, hyperlinks are not working.
Raja Shekhar Reddy.
Jun 27, 2014 08:59 AM|jeeveshfuloria08|LINK
Hyperlinks for sub report, won't work in downlaod/exported excel file from SSRS. You can disable hyperlinks when exporting ssrs report.
Go thorugh below URL: