Hiding Child Group Hides Parent Groups?
Hello, I'm using SQL Server 2008 R2 SSRS. I have data that I'd like to display as follows:
Week| Student | Teacher
|
| Tardy | Absence | Tardy | Absence |
Wk 1 | 5 8 3
4
Wk 2 | 3 2 1
6
Wk 3 | 1 2 7
8
As you can see, I have a parent and child group on the top rows. I'd like to be able to dynamically hide the "Tardy/Absence" group when the user doesn't want to see it, but when I hide it, the top level disappears as well, and I end up with no
data in the report. I expected that hiding the child group would produce data as follows:
Week| Student | Teacher
|
Wk 1 | 13 |
7
Wk 2 | 5 | 7
Wk 3 | 3 |
15
Instead, all I get is:
Week
Wk 1
Wk 2
Wk 3
NO DATA DISPLAYS WITH IT.
Why does hiding the child group produce this unusable matrix result? To create the child group, I right clicked in the top cell, clicked "Add Group", then "Child Group". I'm very frustrated, and hoping someone can help me out.
Thanks!
Mike
November 15th, 2010 6:09pm