Toggled Detail Still Shows First Detail Row When Collapsed
I'm having a problem with a toggled detail group in SRS 2008. I setup the detail group properties to be Shown but toggled based on a cell in the group header two levels above the detail group so that when I toggle all details are collapsed at the same time (not just the details within one of the groups). I've used this approach in other reports. When I run the report it displays all headers and details as I expect. When I collapse the details, the first record of each of the details sections remains visible.How can I get the first detail row of each group to collapse as well?Initial Report:---------------- - Region Product 1 Transaction 1 Transaction 2 Transaction 3 Transaction 4 Transaction 5 Product 2 Transaction 1 Transaction 2 Transaction 3 Product 3 Transaction 1 Transaction 2 Transaction 3 Transaction 4After Collapsing the Region:------------------------------------- + Region Product 1 Transaction 1 Product 2 Transaction 1 Product 3 Transaction 1 Marc Bellanger
August 21st, 2009 7:51pm

Hi Marc, It seems all the detail rows had already been hidden. The first row remained is the group header of product group, but maybe you set the group header with expression like this: =fields!detail.value. So, the group header displays the first value of details and they cannot be hidden because they are product group. Or there is no group header, but since you create product group and there is a product cell, so after you collapse the details, the reporting services will create a header row for the product group, and take the expression =fields!detail.value by default. I think this the reason why you see the first row cannot be hidden. If so, you can try the below steps to add a group header for product group: 1) In row groups pane, click details group, click the small triangle to list the options. 2) Switch to Add totals, click before. It will add a group header for product group. 3) You can modify the header expression or just delete the expression. but dont use something like this=fields!detail.value. Hope this helps. Raymond
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2009 12:12am

Thanks for your suggestion. I think something was corrupt with this report. I tried everything after I received your suggestion, short of recreatingthe entire reportfrom scratch. No matter where (what grouping level) I put the toggle into, the report still responds the same way. It collapses everything except for the first detail row. I added a new detail row and eliminated all of the formatting on it and then built it up from scratch. I've confirmed the visibility settings on each cell in the detail row individually by going into the 'Textbox Properties' window. What seemed to finally get rid of my problem was deleting the group on Product. I deleted it, saved, recreated it, saved and then attached the toggle. Then it started working as expected. Everything else was the same as far as I could tell, but now it works.Thanks again for you feedback,MarcMarc Bellanger
August 24th, 2009 4:27pm

Because you create a product group but no group header, by default, collapses everything, butfor the first "detail row" - actrually, it's group header now.- Raymond
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2009 9:07pm

This was exactly a problem I encountered! Thanks for the instructions!
May 29th, 2012 6:18am

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

Other recent topics Other recent topics