November 26, 2013 at 9:05 pm
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 Globals!RenderFormat.Name option. However I do not know how to write this code. Thus can you show me how to write this code?
November 26, 2013 at 11:59 pm
Didn't I already gave you a blog post that explains how to do this?
Hide/Show Items Dependant On Export Format (SSRS)[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 27, 2013 at 7:46 am
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?
November 28, 2013 at 7:04 am
what about =IIF(Globals!Rendername.Name!='RDL',TRUE,False)
Haven't tested, just a guess?
November 28, 2013 at 2:29 pm
should this be rpl?
November 28, 2013 at 2:36 pm
Hmmm, yes I see your point. The link that Koen posted has RPL in it, yet the code I have in a working report is RDL. not sure what to say...
I may have to test my report again just to make sure it really works, or what happens if I use RPL.
November 28, 2013 at 2:41 pm
Ha! RPL it is. the way I had my IIF set it would have worked even if I had "CAT" in there. Never too late to fix and error you never knew you had. Thanks!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply