Expand/collapse matrix cells

Hi folks - I am trying to figure out how to set up the visibility
(expand/collapse) for my grouped matrix. So for example:
A
A1 10
A2 15
Total A 25
B
B1 35
B2 30
Total B 70
I want the user to be able to click and collapse to just see this:
A 25
B 70
Is this possible? I get the table, but am confused on how the matrix
handles grouping and visibility...
-RyanIn a matrix, you would have two row groupings. One for A, B, etc. and an
inner grouping for A1, A2, B1, etc.
1. For the inner row grouping, edit the grouping expression and go to the
Visibility tab of the grouping and sorting dialog. Set initial visibility to
"Hidden". Then, select "Visibility can be toggled by another reportitem" and
select the textbox of the outer row grouping heading.
2. For the inner row grouping, go to its heading textbox properties and set
the "initial appearance of the toggle" to Collapsed.
I also recommend to look at the sample reports that come with RS 2000 / RS
2005. Specifically, check the "Company Sales" sample report - it should
provide what you are looking for.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan M" <ryan.marples@.bluetidemanagement.com> wrote in message
news:1128026677.096400.11570@.f14g2000cwb.googlegroups.com...
> Hi folks - I am trying to figure out how to set up the visibility
> (expand/collapse) for my grouped matrix. So for example:
> A
> A1 10
> A2 15
> Total A 25
> B
> B1 35
> B2 30
> Total B 70
> I want the user to be able to click and collapse to just see this:
> A 25
> B 70
> Is this possible? I get the table, but am confused on how the matrix
> handles grouping and visibility...
> -Ryan
>|||Thanks for the pointer Robert. It turned out what I was doing wrong is
... applying the visibility properties to the textbox that represented
the group, not the group itself. Now I get it, thanks!
Now if I could just figure out how to get column heading for my row
groups...
-Ryan