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. As a side note, this worked perfectly fine in SSRS 2005 for me. Thanks! Mike

I just tried the same type of report, but hid row groups instead of columns, and the same thing happens. I should be able to hide child groups without affecting parents, but doing so messes up all my reports. I allow my users to select up to 5 levels of depth for columns and rows, and I can't create 5x5 permutations of reports to handle them. I need to be able to hide columns so that I can have 1 report with dynamic hidden columns and rows. In this new example, the expanded report shows: Category 1 Subcategory 1 Subcategory 2 Category 2 Subcategory 1 Subcategory 2 Total If the user only wants to see the Category listing, the report should just show Category 1 Category 2 Total Instead, the report shows no data at all other than the total row. It's as if I hid the parent column with the child. Are they linked together in a way I'm not aware? This is the behavior I'd expect if I were hiding the parent row, but not the child row. Again, this works fine in SSRS 2005.

Hello Can someone help pls,,,,HAving the same problem can't hide the "matrix1_RowGroup2" which i have created for the alternate color of matrix data. If I Hide that row group I can't see anything. Pls help, thanks Cheers Jatin

Hi all, Your steps might be incorrect, please follow these detailed steps to reproduce the reort: 1. Right-click Subcategory group in the Row Groups pane at the left-bottom, and then select Group Properties 2. Switch to Visibility tab, select hide RadioButton 3. Click the checkbox of Display can be toggled by this report item, select Category in the drop-down list. Note: Category is the names of textbox of Category, if the name of the textbox is not Cost Element, please type in the real name. 4. Click Ok Preview the report, you could not see the SubCategory row, click the ‘+’ sign, you could see the detailed information. This is a similar thread, you could click this link http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/2bf867b4-6e1d-45cf-be15-e8ae89049a52 for both version of SSRS2005 and SSRS2008 Thanks, Challen Fu

Challen, Everything worked when I enabled the toggle, which confirms this feature is broken. I export this data to static formats in my web app (PDF, for example), and drilldown is not needed at all. If I click off "display can be toggled", the report is completely messed up. Why can't the data display correctly without a drilldown toggle enabled? It should display the same with or without the toggle when the data is collapsed. This worked correctly in SSRS 2005. I appreciate your help though! Please confirm whether this is a bug or intended behavior. If it is a bug, I'd like to submit it to the dev team. Here is a quick way to recreate it: Open your DB, and run the following quick table create and insert statements: create table test_report (catname varchar(100), gender varchar(1), color varchar(10), age int) go insert into test_report values ('Fluffy', 'F', 'Brown', 15) insert into test_report values ('Candy', 'F', 'White', 8) insert into test_report values ('Noodle', 'M', 'Black', 6) insert into test_report values ('Pearl', 'F', 'Gray', 17) insert into test_report values ('Ruby', 'F', 'Red', 11) insert into test_report values ('Rocky', 'M', 'Black', 9) insert into test_report values ('Spencer', 'M', 'White', 8) insert into test_report values ('Lizzie', 'F', 'Red', 5) insert into test_report values ('Puff', 'F', 'Brown', 3) insert into test_report values ('Spike', 'M', 'Black', 1) Then, create a new report, point it at the table, and use "select * from test_report" as the data source. Create a matrix, add Gender to the left column, Color to the top, and Count(Age) in the aggregate. Then, add a child group on the gender row group, and add "name" to it, and set the visibility of this group to "hide". Notice that the report works if drilldown is enabled, but fails if it is not. In 2005, the report would display with the hidden data, and the data would rollup so it was all included. Mike

Hi Mike, It is true steps of setting drill-down feature in SSRS 2005 is different from SSRS 2008, so the behavior is different as well, I test your sample data, Here if you don't want to display the colomn CatName, you could just keep one row group gender and then delete row group CateName, then it will be as same as the report in SSRS 2005. Thanks, Challen Fu

Hi Mike, It is true steps of setting drill-down feature in SSRS 2005 is different from SSRS 2008, so the behavior is different as well, I test your sample data, Here if you don't want to display the colomn CatName, you could just keep one row group gender and then delete row group CateName, then it will be as same as the report in SSRS 2005. Thanks, Challen Fu This means functionality has been removed in SSRS 2008. I consider this a bug, not an expected change in behavior. Hiding child columns and rows should not affect parents. This means that I can't have a report with 5 columns that display and hide dynamically as needed. It means I need 5 different reports now to accomplish the same thing. And it also means that matrices with dynamic columns and rows are no longer possible. This is a major issue for me, and forces me to reduce functionality in my software's next build. Grrr..... How do we get this filed as a bug? Can you submit it? Can I submit a bug?

Hi Mike, You could have a report with 5 columns that display and hide dynamically as needed. When you create a parent groups, please make sure you select the checkbox of Add group header, then type in the expression =Sum(Fields!datafield.value) on the header row. Then it will have the same behavior as SSRS2005. If you have any concern, please feel free to ask, thanks. Challen Fu

Honestly, I don't feel like this has been sufficiently answered. It seems that multiple users are experiencing the same issue, and I know myself along with other collegues in my office are experiencing this issue. We have set the visibility as outlined above for all of the child groups, leaving the top level parent group's visibility set to "Show". Within the preview in Visual Studio 2008 this works as intended. The row for the parent group is visible and has a toggle button which expands to show the first child group, which has a toggle that expands to show the second child group, and so on... However once deployed to the Report Server the row is complete gone, and the only rows visible for the Tablix are the Header row, with the column titles, and the Total row with the totals. The first thought we had was that the version of Visual Studio 2008 installed on our machines was fully patched, where as the report server was not fully patched. However, the IT team is hesitant to patch the server without reason to believe that will actually fix the problem. Anyone had any luck correcting this issue by installing the latest patches to their development environment?