Post reply

Removing Hyperlink on Exports

  • July 13, 2012 at 4:51 pm

    #261202

    How can I remove the hyperlink on a SSRS report export?

    I added an expression to the Jump to URL to check the Globals!RenderFormat and either it returns "" or a javascript string that jumps to the target URL.

    Previously, the javacript string without the IIF logic, would jump to the URL without any problems.

    ="void(window.open('http://server_name/app_name/report.aspx?iID=" + Fields!ID.Value.ToString() + "&origin=Search','_self'))"

    But now that I added the IIF logic, it does remove the hyperlink from the exports, but the hyperlink on the search results no longer work.

    =IIF(Globals!RenderFormat = "PDF", Nothing, "void(window.open('http://server_name/app_name/report.aspx?iID=" + Fields!ID.Value.ToString() + "&origin=Search','_self'))")

    Ideas anyone? Thanks.

  • July 16, 2012 at 8:44 am

    #1513117

    try....

    Globals!RenderFormat.Name

    OR

    You could also use the .IsInteractive property, which will disable the links for PDF exports as well:

    IIf(Globals!RenderFormat.IsInteractive, "YourReportPath", Nothing)

  • July 16, 2012 at 11:27 am

    #1513223

    Thanks! The Globals!RenderFormat.Name fixed it!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply