Dear All, I have a report with many fields displaying in the report. I am checking the visibility of the columns. When i am defining a separate parameter of boolean type iam able to hide the column visibility using the following xpression, =IIf(Parameters!Col1.Value="True",False,True) Now i have defined a parameter of Data type = text, allows multiple values Available values - in 'Specify Value' have specified the resulting column names in the Label and Value fields. No Default Value. So the parameter field holds all column names in a combobox with check box aside. i am trying to hide the columns with the expression in the column visibility properties. but i am not able to use the same xpression, for it is only taking the parameter name in xpression but not the defined combobox values. kindly help me with the formula.. I need to display the columns that are alone checked in the parameter combobox value. Thanks !!

I am not sure whether I have understood your requirements correctly. My understanding is that you have a multi-select report parameter which contains the list of column names that you would want to display. Suppose your rep parameter name is ColName and your column names are A1, A2, A3, A4 and A5. Suppose you select A1 and A3, you would want to display A1 and A3. This can be done by going to each of the column names and putting this in the visibility =iif(instr(Join(Parameters!ColName,","),"A1")>0,"False","True") =iif(instr(Join(Parameters!ColName,","),"A3")>0,"False","True") You have to do this for all the columns. This is when you have defined 5 columns in your tablix. But suppose you just have a column group called A which may have values (A1 to A5) depending on the data. In this case, it is better to limit the dataset query by putting the report parameter in the where clause. Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Dear Jason ! Thanks ! I tried your formula.. but its letting to error as below, [rsCompilerErrorInExpression] The Visibility.Hidden expression for the tablix ‘table1’ contains an error: [BC30518] Overload resolution failed because no accessible 'Join' can be called with these arguments: Kindly help me to solve.. many Thanks !

Select "Allow Multiple values" in the parameter properties. That should solveyour issue.

Select "Allow Multiple values" in the parameter properties. That should solveyour issue. HI ! its already got selected. Still the problem.. any help ?? Thanks In Advance!

What is the value you have chosen for "Allow Blanks" ? Did you try to run the report with blank parameter ?

[quote]What is the value you have chosen for "Allow Blanks" ? Did you try to run the report with blank parameter ?[/quote] It is selected for allowing blank values. But when trying to preview, the error only comes first in prior to displaying the report page. Any help.. Thanks !!

I am not sure whether I have understood your requirements correctly. My understanding is that you have a multi-select report parameter which contains the list of column names that you would want to display. Suppose your rep parameter name is ColName and your column names are A1, A2, A3, A4 and A5. Suppose you select A1 and A3, you would want to display A1 and A3. This can be done by going to each of the column names and putting this in the visibility =iif(instr(Join(Parameters!ColName,","),"A1")>0,"False","True") =iif(instr(Join(Parameters!ColName,","),"A3")>0,"False","True") You have to do this for all the columns. This is when you have defined 5 columns in your tablix. But suppose you just have a column group called A which may have values (A1 to A5) depending on the data. In this case, it is better to limit the dataset query by putting the report parameter in the where clause. Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :) hi plz .. i guess i am near the solution.. Kindly do help me.. i did checked with modifying the formula by some way..but.. not getting the report correctly.. i need some help for the error im getting.. Thanks in advance !!

Hi, Based on the expression Jason posted, plese fixed it like below =IIf(Instr(Join(Parameters!ColumnName.Value,","),"A1")>0,False,True) Thanks