asked
SSRS Hide Columns Based on Paramater
I have been trying to use a tablix report and hide the columns based on a paramater. The report needs to behave like a matrix report - but in matrix - the problem is that you can add column headings to the area which you need to pivot on and then the criteria being pivoted needs to have the items reapeated in the groups so I am trying the method to hide a tablix report columns based on parameter (multi-value select) and I have not been successful. can someone please describe the method to do this step by step? Are the parameters only encased in the rdl (or do they also have to match data source paramters) either way - I am using a stored proc for a data source and I can use mult-value select in the matrix so i know my multi-value select works - i just cant hide /show columns with the paramater selection... I appreciate any assistance
I got it - I found a microsoft thread that resolved it you have to use iif(InStr(Join(Parameters!Param.Value,","),"4")>0,False,True) in order for the selection to search the entire array for the term
Congratulations on finding your answer and thanks for posting it here for others to use if they have the same problem.
Ok - I have multi-value paramaters working - And I have Hiding columns working Just not together - I have a total of 6 potential selections But when i start skipping items to choose it's throwing outside the array error - so if i choose not to use the first three options and olny the last three - the last three iif statements to show parameters are =IIF(Parameter!ITEM.Value(3) = "1234", False, True) =IIF(Parameter!ITEM.Value(4) = "6789", False, True) =IIF(Parameter!ITEM.Value(5) = "9876", False, True) Then the items chosen in my multi values only reach 0, 1, 2 How do I make my options in the array static to the ones they need to match
