Hello, I have been researching this issue for quite sometime and have implemented some of the solutions that were suggested from these links. http://social.msdn.microsoft.com/Forums/en-za/sqlreportingservices/thread/d6159ee3-8e1c-4d35-a019-85a90f03d6d8 http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c018cf4e-1e84-4063-a2a5-15240d35762b I have similar issue as others where I have grouping in the report. Group A Group B Group C Group D Group E Etc... Starting from group C its adding a duplicate row per group... Any help would be greatly appreciated seeing that this is business critical report that worked when exported to excel in 2005 version.

Hi hobbesnp, The extra row is a generated auto subtotal that in this case is the first row of the group. The reason behind the extra row is to provide at least one row for excel that always displays regardless the toggle state. Now there is a way to avoid it: there are two groups in the table and Group1 has a header row that can be used by Detail group as a toggle item. The attached report is almost perfect, however there is a static node that represents the detail row and it’s supposed to belong to the Detail group, and instead it is a child of its parent which causes the problem. You can fix the report: select the second column and insert a column to left. Copy the cells from the first column and delete the first column (notice a double dash line that separates the first column from the rest: it has to disappear). Don’t forget to change the name of the cell that contains “Business Unit” to Group2 to keep the toggle reference. Try to render the report. This issue is by design, for more information please refer to the following link: Reporting Services 2008, group by export to excel duplicate rows: https://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok Currently, since this issue might be urgent to your business, you could also contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you in a more efficient manner. However contacting phone support will be a charged call, but it will be free if this is a product issue. To obtain the phone numbers for specific technology request please take a look at the web site listed below. http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS Thanks, Eileen