Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2010-02-16 : 08:46:36
|
| Hi,In the SSRS reports, there is a button to export the report to Excel.One of the fields in the report table is a hyperlink (When you click on it, it jumps to another report).When the report is exported to excel, it also carries the hyperlink too.Do you know how to prevent the link to appear in excel. I would like to export the fields and if they have links then to appear as normal text in excel.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-16 : 13:21:12
|
| what we did in such cases was to create a copy of main report and renaming it to excel version and then add a new export to excel link in report which does nothing more than jump to other copy renamed as excel. In that report we remove links given on figures. however, if you're using ssrs 2008 you can use an expression like below for Text Decoration property=IIF(Globals!RenderFormat.Name="Excel","None","Underline")------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-17 : 02:58:05
|
| I have the following cod einside the expression:=Fields!code.Valueso where do I place the IIF you mentioned pls?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-17 : 03:03:40
|
quote:
Originally posted by arkiboys
I have the following cod einside the expression:=Fields!code.Valueso where do I place the IIF you mentioned pls?Thanks
It works only if its ssrs 2008 r2 and you need to give the expression inside expression window foor text decoration property of the cell (accessed by selecting cell and view properties on rightside you get property explore and look for text decoration. inside that give my expression------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-17 : 03:13:07
|
| Many thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-17 : 03:16:43
|
welcome  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
export to excel