Remove hyperlink when exporting to Excel

How do I remove hyperlinks from reports that are exported to Excel?Help, I have the same problem. I added actions to all my text fields to
allow me to filter the report when a user click a cell. I had no idea this
would totally ruine the report when exporting to Excel (each cell is now a
live hyperlink to the live report - FROM EXCEL!!) Te sheet has grown from a
couple hundred K to 22 MB!!! How can I have these textboxes revert to just
plain text when exported to excel. This is an emergency!|||Essentially, you'll write an expression for:
Navigation:
=IIF (Parameters!render_format.value <> "html", nothing, "[report name]")
Text Decoration (to underline if a hyperlink):
=IIF(Parameters!render_format..Value = "HTML4.0","Underline","None")
Color:
=IIF(Parameters!render_format..Value = "HTML4.0","Blue","Black")
Scott
"Estella Kang" wrote:
> How do I remove hyperlinks from reports that are exported to Excel?sql