Friday, February 24, 2012

Hyperlink in Excel

Hi.

When creating a report builder and exporting to excel, the excel file keeps the hyperlinks. How can this be switched off ?

Many Thanks.

Sorry, hyperlinks are always included on all output formats. There isn't any way to turn them off for a particular renderer.

If you explain your scenario, we may consider it for a future release.|||We are having the same issue of clearing out the hyperlinks from excel sheet rendered using sql reporting services.

The scenario is once the report is generated in report viewer, we require the hyperlinks to navigate to other linked reports. But when we export the report by clicking on the export link available on report viewer, we want to remove the links in the excel worksheet.

When the export link is clicked on report viewer i do not have any exclusive control where in i could identify the click event of the export type as Excel selected from the drop down.

Thanks

Sups
|||I understand what is being asked, and would like to see it as a feature. I have many reports that link to other reports for drill-down. When view in the report viewer everything is great, however when exported the link is something like "http://reportserver/ReportName?parameters" which is not a valid URL. It would be nice if this was removed from excel so as not to confuse the end consumers of the report.

No comments:

Post a Comment