SSRS Report Builder Part 6.6 - Collapsible and Expandable Table Groups

By Andrew Gould
www.wiseowl.co.uk - This Report Builder video teaches you how to create table groups which your users can expand and collapse using basic interactive controls. You'll learn how to alter the visibility of rows and tablix items and how to assign a toggle item so that your users can show and hide the grouped data. You'll also see how to create nested interactive groups and discover how to export the same interactivity to an Excel workbook.
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link www.wiseowl.co... to make a donation. Thanks for watching!
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more

[@DanielCalbimonte]

Best SSRS tutorial on the web ever! Thanks.

[@WiseOwlTutorials]

Thanks for watching Daniel!

[@joegarrard86]

This is a great video, thanks for explaining the process so clearly and concisely. Has been extremely useful

[@WiseOwlTutorials]

Happy to hear it was useful, thanks for watching!

[@alxvseti]

02:29 Basic Grouped Table
06:40 Hiding the Details Rows
07:55 Hiding the Group Header and Footer
09:00 Toggling the Visibility of Rows
10:57 Adding a Nested Group
12:28 Collapsible Nested Group
14:47 Changing the Initial Toggle State
17:01 Exporting the Results to Excel

[@LUPECARREON]

I love this video. Thank you kindly for sharing your knowledge

[@WiseOwlTutorials]

You're very welcome, thank you for watching!

[@maksympt1]

always very helpful. these videos are golden.

[@WiseOwlTutorials]

Thanks Maks, happy to hear that you found it useful and thanks for taking the time to leave a comment!

[@doupanpan7271]

this is awesome, thank you so much for explaining things so clear.

[@WiseOwlTutorials]

You're very welcome, thank you for watching!

[@cde1640]

Initial Toggle State = True... You saved me !!!!

[@henriquedosprazeresmarceli1525]

excelent vídeo! Salveexcellent vídeo! this is saved my life kkkk!

[@WiseOwlTutorials]

Happy to hear it Henrique!

[@SrinivasaKoppula]

It is very helpful tutorial

[@dgendev]

+1 sub, love it!

[@cihandurmaz8887]

nice job!

[@TheseLocalGods-os6cu]

Excellent super informative. 99/100 - you're losing a point because of the unaccountable Twilight beef😉

[@WiseOwlTutorials]

Fair enough! There's no accounting for taste 😉

[@YpunkStudios]

When I click on my toggles, the data disappears. How do I prevent that from happening?