Column Visibility in SSRS 2008

Question

Post reply

Column Visibility in SSRS 2008

kkishore1010

Mr or Mrs. 500

Points: 587
More actions
January 24, 2011 at 8:29 am

#230830

Hi All,
Currently working on SSRS 2008, i want hide a columns depends on parameters which will be select by the User.
In column visibility expression this code i am using
"=IIf(Parameters!ParameterName.Value.Equals("1"),True,False)"
But this seems not working.
Could any one help me out by getting thanks in advance!!!!!!!!!!!
for example:
Parameters= a,b,c Parameter b as values of 1,2,3
columns= 1,2,3
If user select in the parameter b as 1,2 then display should be coulmns1,2
If user select in the parameter b as 1,3 then display should be coulmns1,3
Thanks,
kumar

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

Daniel Bowlin

SSC-Dedicated

Points: 34566

January 24, 2011 at 12:52 pm

#1277427

Is this a multi select parameter?

kkishore1010 Mr or Mrs. 500 Points: 587 More actions · Answer 2

kkishore1010

Mr or Mrs. 500

Points: 587

January 24, 2011 at 12:56 pm

#1277430

Is its is MultiValue Parameter

kkishore1010 Mr or Mrs. 500 Points: 587 More actions · Answer 3

Thanks for Reply

Yes it is a Multivalue Parameter!!!!!!!

If you can tell me the solution in SSRS 2005 and SSRS 2008 that would be really great!!!!!!

Thanks,

kumar

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

I have a similar requirement that I haven't finished building yet, but here is what I think will work

=IIF(InStr(JOIN(Parameters!ParameterName.Value,", "),"ValueToTestForColumnVisibility"),True,False)

kkishore1010 Mr or Mrs. 500 Points: 587 More actions · Answer 5

Thanks Its working fine!!!!

But if user wants to select all columns at single click how can we write the expression

ALL,

how to write the statements??

Thanks,

kumar

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 6

As far as I know you have to write an expression for each column's visibility

kkishore1010 Mr or Mrs. 500 Points: 587 More actions · Answer 7

Hi Daniel Bowlin,

i am using the below expression to get the all parameters to be selected with ALL button for the parameter.

example:

parameter b: ALL,Column1,column2,column3

I can able to hide the column1 indivdually with the below expression

IIF(InStr(JOIN(Parameters!Parameter.Label,", "),"Column1"),False,True)

I want to show all columns if user selects like "ALL"

IIF(InStr(JOIN(Parameters!Parametername.Label,", "),"ALL"),IIF(InStr(JOIN(Parameters!Parametername.Label,", "),"column1"), true, False) ,True)

so please let me know whether we can write any kind of code to select all columns with ALL button.

Thanks in advance,

kumar

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 8

If paramater b is a multi select it should show an All choice. Selecting the all choice will return all the items in the multi select list, not just All. So the first draft of the forumula should still work. If you want an actual button to click and select All and pass the value/label "All", I do not know how to do that.