SSRS export to Excel has invalid group footers

Question

I have a SQL Server Reporting Services report that has several levels of groups. Groups have footers but no headers. Each subgroup visibility is initially hidden and can be switched from a cell in the footer of its parent group.

The report is perfectly displayed in the browser. However, when I export to Excel, groupings are wrong. With three layers of groups, the last element of the second layer is not compressed in Excel. The last element in the third layer is reset, but does not initially crash, as it should be, and is located in the browser.

Is there anything I can do differently to make this work?

Answer 1

I do not have enough reviews to add comments, so I post my comment here.

You summarize expressions in lines like this.

=sum(Fields!MyField.Value)

I noticed with excel that it has no way to conditionally present a summation like the one above when you reset a group.

This means that the information must go somewhere, since excel will not trim the information and is represented by adding a row with the summation equal to the expression = sum () in excel.