all groups > sql server reporting services > february 2006 >
You're in the

sql server reporting services

group:

Matrix Column Grouping


Matrix Column Grouping John.Aaron.Nelson NO[at]SPAM gmail.com
2/20/2006 3:31:59 PM
sql server reporting services:
What would be the best solution to accomplish the following?

The report would look as follows

Year 1 Total Year 2

Month 1 Month 2

Total items 25 12 5
Item type 1 8 9 4
Item type 2 7 2 3
Item type 3 9 5 1

When you click on the Year 1 totals, the detail months should expand
and shift everything to the right.

Just like in a table, you can hide the detail rows of a table, I would
like to hide/unhide the detail columns of a Matrix. However, when I go
to toggle the visibility of the column like I toggle the visibility of
a row in a table, it only hides the column header (obviously because
it's only toggling the visibility of the textbox itself instead of the
entire column). Is there any way to toggle the visibility of a column
in the same manner you do a row in table?

This could also be accomplished with a Table, utilizing static columns,
but that is not ideal.

In Excel, all that needs to be done is to is to group the headers, and
use the new group field to display the PivotTable headers.

Is there an easier/better way to accomplish what I'm trying to do?
Re: Matrix Column Grouping John.Aaron.Nelson NO[at]SPAM gmail.com
2/20/2006 3:40:52 PM
After hours of searching, shortly after I wrote this, I found the
answer here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_0zvx.asp

So nevermind.
AddThis Social Bookmark Button