I have a SQL Server Reporting Services report that has several layers of groups. The groups have footers but no headers. Each sub-group's visibility is initially hidden and can be toggled from a cell in the footer of its parent group.
The report renders fine in the browser. However, when I export to Excel the groupings are wrong. With three layers of groups the last item in the second layer is not collapsable in Excel. The last item in the third layer is collapsable but not initially collapsed like it should be and is in the browser.
Is there anything I can do differently to make this work?