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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-26 : 23:03:19
|
| In an existing SSRS 2008 R2 report, I want to show or hide detail columns based upon all the export options a user can select from. Basically I want to show or hide columns based upon any value a user selects in the .Name option. However I do not know how to write this code. Thus can you show me how to write this code? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-27 : 05:00:03
|
| I want to show or hide columns based upon any value a user selects in the .Name optionis Name a parameter in report?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-11-27 : 09:39:48
|
| Name is not a parameter in report.There are 7 built in options for exporting SSRS reports.. I was wondering if there is an easier way to code the following in SSRS when chosing the export option:=IIF(Globals!RenderFormat.Name="WORD" OR Globals!RenderFormat.Name="XML" OR Globals!RenderFormat.Name="CSV" OR Globals!RenderFormat.Name="TIFF" OR Globals!RenderFormat.Name="PDF", Globals!RenderFormat.Name="MHTML" OR Globals!RenderFormat.Name="EXCEL",true,false)Is there a way to write the code above without having to list each export option listed? A way that includes all the export options? If so, how would you write that code? |
|
|
|
|
|
|
ssrs 2008 r2 Globals!RenderFormat