I have a report in SSRS 2008, in which we are grouping the rows by a combination of 3 columns ( Dept ID, Sales Rep Name, Activity Recruiter) reports works great in Visual Studio and every where. But when we export the report to Excel we are getting one more extra row apart from the expected number of rows. I am not sure how I can attach the attachment for better understanding ...if some one wants to have a look at the screenshot pls let me know I will pass the same....

Hi, There is similer bug report created for SSRS 2008 https://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok You can have a look at commnets for it, see if some solution applies to you also. - Chintak (My Blog)

Hello Chintak, I have read the post given by you and tried to implement the same solution but no luck. If you want to have a look I can FWD the RDL and the screen shots. Regards, Ashwar

Hello Ai-Hia, I have implemented these steps and the problem persists. If you want to have a look I can FWD the RDL and the screen shots. Regards, Ashwar.

Hi, This is by design. There is a workaround to fix the report. We can refer to the following steps: 1. Choose the second column and right-click, 2. Insert a column to left, 3. Copy the cell from the first column and delete the first column. When I export the report to an Excel file, the result is: Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, I am using the TABLE control to fix the report, please refer to the following steps: 1. Choose the second row and right click. 2. Choose Add Group, and then choose Parent Group. 3. On the Tablix group, choose Region as Group by. 4. Click Add group header. 5. On the Group properties, set visibility. When I export the report to an Excel file, the result is: Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hello Ai-Hua, Thanks a lot for the response and I have implemented the steps you have specified and we have come real close to solving the issue, but not 100%. I think we need to discuss on this issue further. My linked In profile is at -- http://www.linkedin.com/pub/ashwar-hussain/9/328/354 and you can email me at ashwarhussain@yahoo.com. I feel we should have a look at the RDL and the error screen shots. Please let me know how can I reach you and get helped by you. Regards, Ashwar

Hello Ai hua, Thanks a bunch for the response and the hints to solve my Issue. I have implemented the steps specified by you, and we are very near to soving the probs but not there 100%. I think we need to discuss more on this issue, specific to the the RDL. I will FWD you the RDL file, and the error screen-shots if you need to have a look. My linked is at http://www.linkedin.com/pub/ashwar-hussain/9/328/354 and you can email me at ashwarhussain@yahoo.com <<Partially Answered my Question>> Regards, Ashwar.

Hi, Could you send me your RDL file? E-mail: sqltnsp AT Microsoft.com (Please replace AT with @). Please send me with the following format: Subject: MSDN/TechNet forum question: <Thread Title> Attachments: <files> Hi Ai-Hua, ThreadURL:<URL> <Additional information> Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hello Ai-Hua, I have emailed you the RDL and the screen shots for reference. Thank you Regards, Ashwar

Hi Ashwar hussain, I understand your meaning completely. According to Microsoft, the goal when exporting to excel is to match the visual appearance of the report as close as possible. The excel output may have unexpected things like extra rows or columns or merged cells as part of the process to match the layout. To work around the issue, you could add a parent group header when you create the first parent group(GroupByDeptIdRecruiterSalesRep), then you will not have this duplicated total row at the back of group, but there is a header at the parent group, so this is just a workaround not a grace solution, thanks for your understanding. I have attach designed report at email. Hope this help you. 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 Regards, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.