I have a tablix report with grouping and toggling as follows:
RowGroups
RowGroup1 Hidden: false, InitialToggleState: true
RowGroup2 Hidden: false, ToggleItem: RowGroup1
RowGroup3 Hidden: false, ToggleItem: RowGroup1
RowGroup4 Hidden: true, ToggleItem: RowGroup3
ColumnGroups
Year
The report details is a Sum of "cost". All the details and groups are on one row in the report. When I view the report everything except RowGroup4 is visible, and I can toggle that group to expand the detail. The problem occurs when I export to Excel. I am getting a duplicate row.
I have read about the issue at http://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok but I don't understand what i have to do to implement the workarounds described. I tried the hidden row workaround by right clicking on the TextBox linked to RowGroup1 then Insert Row - Outside Group Above, then right click on the new row -> Row Visibility -> Hide. But it made no difference to the export