SQL Server - Removing hyperlinks in SSRS excel export

Asked By Naga

21-Jan-10 06:28 AM

Anyone know how to remove the hyperlinks before exporting the data into
excel. The exported file is becoming five times because of the hyperlinks. Is
there any setting which can be done in rdl file?

21-Jan-10 01:53 PM

Naga,

As far as I know, there is no way to do this in SQL 2005/08.  I
checked the Device Information Settings for Excel
(http://msdn.microsoft.com/en-us/library/ms155069.aspx), but there
does not seem to be a setting to set for this.  As a workaround, you
could add a parameter that the user could choose to include\exclude
hyperlinks.

In SQL 08 R2 there are new Built-In fields that expose the Render
Format and thus you could changes things in the report via expression
based on the RenderFormat  RenderFormat.Name and
RenderFormat.IsInteractive
(http://msdn.microsoft.com/en-us/library/dd255216%28SQL.105%29.aspx)

Hope that helps,
Andrew
SQL Server MVP