reporting-services
i've a table, where some cell have an action: Go to report (to a detail report).
When user click, SSRS send user to the sub report.
But i need to cancel the hyperlink when user export the report in excel. How can i do ? I know exists Globals!RenderFormat but i don't know how to use it to tell SSRS not to export hyperlink.
Thank you
Write the following expression to disable the page-break during export to excel :-
IIF(Globals!RenderFormat.Name = "EXCEL",TRUE,FALSE)
Two approaches, the first assumes data is pre-formatted as a URL (e.g. https://www.google.com). The second assumes the URL is contained within some other text (e.g. 'This is a link to Google').
Right-click the field in design view, select Text Box Properties.
Select the Action pane, select the Go to URL radio button.
In the Select URL textbox, enter the field value expression.
Double-click the field in design view, then right-click Create Placeholder.
In the Value textbox, enter the field value expression containing HTML tags.
Under Markup Type, check the HTML - Interpret tags as styles radio button.
Verify link is displayed when report is run.
Best Answer
You'll need to go to the Action section on the cell which has the hyperlink. You probably have set the "Go to Report" action. Instead of just specifying the report, you'll need to specify an expression for it instead, something like this:
OR you could also use the .IsInteractive property, which will disable the links for PDF exports as well: