0
votes

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

1

1 Answers

3
votes

You can add row inside RowGroup3 ("Inside Group - Above") as in this image:

enter image description here

This will show empty row for collapsed group but there won't be duplicated rows in Excel report.