question

siera_gld avatar image
siera_gld 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
ssrscolumnshide
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

siera_gld avatar image
siera_gld answered
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
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Congratulations on finding your answer and thanks for posting it here for others to use if they have the same problem.
0 Likes 0 ·
siera_gld avatar image
siera_gld answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.