How do I hide a matrix column?

2
votes

I have a matrix in SSRS 2008R2. It has the following features:

  • 2 Row Groups (X,Y from let to right as you look at the report)
  • 1 Column Group (Date)
  • Y is toggled via X; and when first rendered Y groups will not be visible

I'd like all column Y to be initially Visible=False, then if a user expands any of the items in column X, say group item Q, then column Y becomes visible, and all the items in Y associated with Q are also visible.

I understand about using the (Static) columns to expose the column vibility property and I've created a Boolean variable IsYvisible, and used this in the property so that there is now a radio button which switches the column visibility - I want the visibility of column Y to be toggled whenever a user clicks on any of the "+" signs in column X.

1
sql-serverreporting-servicesreportssrs-2008rdl
A screenshot of your groups and columns would help a lot. Is Row Group Y a child or a sibling of Row Group X? Is Column X related to Row Group X? Column Y related to Row Group Y? – Jamie F
(hmmm!)..is it easy to add screenshots to stackOverflow posts?! – whytheq
Yes it's easy to add screenshots. When you edit your question, there will be a small image icon. Clicking on that will allow you to attach an image from your machine. I believe this is available to all users with more than 10 rep. – Jamie F

1 Answers

-1
votes

Select the tablix and right-click the grey button at the top of your Y column, then select 'Column Visibility'.

Use that for your hide/show/display toggle settings, it sounds like you hid the text boxes inside the column resulting in your blank space.