question

etroxel avatar image
etroxel asked

Hide/show a column in matrix based on toggle.

Hi I am attempting to hide/show a column based on toggles in a matrix. My matrix is really a matrix within a matrix was looking like this:![alt text][1] There are a dozen or so more rows below and approx. 30 columns more to the right. The white space is there because of the second matrix which holds the detail of what makes of the numbers:![alt text][2] [1]: /storage/temp/4497-trh-fs31trhmcorgusers31u19346my-pictures1.png [2]: /storage/temp/4498-trh-fs31trhmcorgusers31u19346my-pictures2.png What I need is to have this report run initially with the 2nd matrix collapsed and then use the toggles to expand it so that detail is shown as needed by the user. I have another version of the report where I was able to add another toggle to the cost center number. However the user then needs to click on the cost center toggle first before they can access the detail of the individual totals. That is not going over very well.... If there is a way to link the toggles...if a toggle in the body of the matrix is clicked, the column toggle expands that would be great. Ideas?
ssrsreporting serviceshidematrix
10 |1200

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

0 Answers

·

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.