How to remove drill bits and normal hyperlinks in Excel version of reports?

Question

Suppose a report is displayed on a report server when a user saves it in Excel format. Then the user opens the report. All hyperlinks and scans in the report are available in Excel, but if the user clicks on it, he opens the result in a web browser.

How to limit these hyperlinks when exporting to Excel from a report server?

Answer 1

You can use the expression in the ACTION option - GO TO REPORT = IIf (Globals! RenderFormat.IsInteractive, "Your report", nothing) this will remove the hyperlinks for exporting Excel and PDF