title: Reporting Services 2008 Exporting Duplicate Rows to Excel
body: <p>I have a tablix report with grouping and toggling as follows:</p>
  
  <p><strong>RowGroups</strong> </p>
  
  <p>RowGroup1 Hidden: false, InitialToggleState: true </p>
  
  <p>RowGroup2 Hidden: false, ToggleItem: RowGroup1 </p>
  
  <p>RowGroup3 Hidden: false, ToggleItem: RowGroup1 </p>
  
  <p>RowGroup4 Hidden: true, ToggleItem: RowGroup3</p>
  
  <p><strong>ColumnGroups</strong> </p>
  
  <p>Year</p>
  
  <p>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.</p>
  
  <p>I have read about the issue at <a href="http://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok" rel="nofollow">http://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok</a>
  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</p>