Removing Hyperlink on Exports

• Mister Ken

  SSChasing Mays

  Points: 659

  More actions

  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.

• Conficker

  SSCommitted

  Points: 1507

  More actions

  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)

• Mister Ken

  SSChasing Mays

  Points: 659

  More actions

  July 16, 2012 at 11:27 am

  #1513223

  Thanks! The Globals!RenderFormat.Name fixed it!