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
Showing posts with label hyperlink. Show all posts
Showing posts with label hyperlink. Show all posts
Friday, March 30, 2012
Remove export options
I only want to provide my report users the ability to output to PDF. I tried setting toolbar=False and adding my own rendering hyperlink to PDF on my web page, but when I set toolbar to false I do not get a horizontal scrollbar for a wide report so I had to turn toolbar=true back on.
Is there a way to not provide any Export options except PDF in the standard Export drop-down?See previous post on this question:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=adca0a75-0f75-48f1-bf52-ed68869ddfc2
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:61F4003D-5988-470A-9EA6-9DDA303DB67B@.microsoft.com...
> I only want to provide my report users the ability to output to PDF. I
tried setting toolbar=False and adding my own rendering hyperlink to PDF on
my web page, but when I set toolbar to false I do not get a horizontal
scrollbar for a wide report so I had to turn toolbar=true back on.
> Is there a way to not provide any Export options except PDF in the
standard Export drop-down?sql
Is there a way to not provide any Export options except PDF in the standard Export drop-down?See previous post on this question:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=adca0a75-0f75-48f1-bf52-ed68869ddfc2
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:61F4003D-5988-470A-9EA6-9DDA303DB67B@.microsoft.com...
> I only want to provide my report users the ability to output to PDF. I
tried setting toolbar=False and adding my own rendering hyperlink to PDF on
my web page, but when I set toolbar to false I do not get a horizontal
scrollbar for a wide report so I had to turn toolbar=true back on.
> Is there a way to not provide any Export options except PDF in the
standard Export drop-down?sql
Subscribe to:
Posts (Atom)