SSRS 2008 - Getting Duplicate Rows when Exported to Excel that do not show in the Web report
Hello - I have a report in SSRS 2008 with a detail row for each day of the week and I've grouped this by week so I can put a space (blank header) at the beginning of each week. It looks great on the web but when I export to Excel 2003, the last row in the group (Friday's data) is repeated twice, once within the group and once outside the group at the bottom. In Excel, when I click to close the Week group, the details rows disappear but the extra Friday still shows. If I look at themarkings on the left of the rowsthat indicate what is part of the group, the extra Friday has no mark beside it that would indicate it is part of a group.I'm not sure what I did that caused this and I'm not sure how to correct this. Any suggestions?Thanks.PositivelyPositively
March 31st, 2009 9:20pm
Hello - I removed my group and redid it and the duplicate lines disappeared. So I'm okay now but I still don't know what caused theduplicate linesin the first place. Has anyone else encountered this before? I'd like to make sure that I don't repeat the problem.Thank you.Positively
April 1st, 2009 2:52pm
This was not a problem in SRSS 2005.This started happening in the new SRSS 2008.I would love to hear a fix for this. I noticed that rebuilding a tablix can sometimes fix the problem. But sometimes it does not.It may have something to do with the order you create groups or how you create them.
September 16th, 2009 5:58pm
Hi - we had the same issue when migating from 05 to 08. We have managed to fix the tables converted to tablix but not the matrix to tablix. Does anyone know how to prevent all row totals being added by the excel renderer on export. Our customers do not wish every row to be totalled. Any help would be most appreciated as this problem occurs in bids, report builder 2 and on SQL 2008 sp1 and rtm. Thanks in advance
September 29th, 2009 5:57pm
Same problem here, it would be very generous if MSFT would somehow address this issue and provide a fix (hot or cold doesn't matter as long as it gets fixed).
November 4th, 2009 6:57pm
Microsoft has stated that it is "BY DESIGN"https://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok?wa=wsignin1.0This is ridiculous. I have 100+ reports that we just migrated from RS 2005 to RS 2008 - and now all the excel exports are broken.Joseph W. Leathlean
February 19th, 2010 11:28pm
Hey Positively and Joseph, I had the same problem too. I googled this issue and get to this page. Positively's redid inspired me. There are two ways of adding a parent group in SSRS. One is draging a field on top of some group, like "detail", in the Row Groups field. The other is right click a group, choose add group -> parent, then you choose a field to group. Also, you can see two check box there, add header and add footer. By default, they are unchecked. Check either of them, there will be header or footer in the group. The first way does not give the header/footer option. Here comes the difference. If you have header or footer in the group, then export to excel work fine. If you donot want to see the footer or header, go to the advanced mode of the group area, there will be two static group above and below the childgroup at the same level. They are the header and footer. Set their Hidden property to true, you will not see them in the report. Though hidden, they are still there, then the S(uper)S(tupid)RS is cheated and will not make duplicate rows when export to excel.
February 25th, 2010 11:14pm
I actually found that my issue isn't caused by this bug. I have designed several of my reports to be both Drilldown and Raw Export reports. So depending on a parameter I will hide the Group Header/Footer rows by putting a formula in the Visibility field of the row.What I found is that if I specifically select Hidden or Show - the report will export perfectly in both scenarios. It's only when I put a formula [ =iif(Parameters!Layout.Value="Raw",True,False) ] that the duplicate rows start showing up during an Excel Export.Time to submit a bug... :(Joseph W. Leathlean
February 26th, 2010 8:03pm
Joseph, Did you get anywhere with solving this? I am having the same problem with SSRS 2005 (SP3) I have a very similar situation to yours - I have a formula like =IIF(Parameters!GroupBy2.Value = "", True, False) in the Hidden property of the TableRow (so users can pick which fields to group by up to 4 levels). If I leave the Hidden property as False everything works OK. Also, even with the above formula in the Hidden property, when exporting to Excel from the development environment (SSBIDStudio) the export works correctly! It is only when running on the SSRS server that the problem occurs...
April 1st, 2010 1:06pm
hello, you've got the answer here, in what Lubo Plaskon says: http://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok good luck
April 7th, 2011 10:45am