locked
Error message when clicking hyperlink in Excel file RRS feed

  • Question

  • User-920422175 posted

    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?

    Thanks,

    Raja Shekhar Reddy

    Tuesday, June 24, 2014 9:57 PM

All replies

  • User-734925760 posted

    Hi,

    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:

    http://[instance_name]/ReportServer/Pages/ReportViewer.aspx/[ReportPath]

    We should make sure the permissions for the subreport.

    There is a similar thread, please refer to the link below:

    http://stackoverflow.com/questions/14809224/exporting-a-ssrs-report-with-jump-to-report-in-excel

    Hope it's useful for you.

    Best Regards,

    Michelle Ge

    Thursday, June 26, 2014 2:20 AM
  • User-920422175 posted

    Hi Michelle,

    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.

    Thanks,

    Raja Shekhar Reddy.

    Thursday, June 26, 2014 11:03 PM
  • User-1051986203 posted

    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:

    http://technicalsmile.blogspot.in/2012/10/disable-hyperlinksjavascript-when.html

    Friday, June 27, 2014 8:59 AM