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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics