Duplicate of records in ssrs csv export
Hi everyone, I have a report system (ssrs r2 2008) that exports data to pdf, word, csv and excel files. Everything works file, except that my i keep getting duplicates of my records, as follows: Category Name Quantity Product Sales Beverages 2 1008 Condiments 4 3602 Confections 5 2857 Category Name Quantity Product Sales Beverages 2 1008 Condiments 4 3602 Confections 5 2857 Instead of: Category Name Quantity Product Sales Beverages 2 1008 Condiments 4 3602 Confections 5 2857
June 5th, 2012 11:17am

In which export format do you see the duplicates?For every expert, there is an equal and opposite expert. - Becker's Law My blog
Free Windows Admin Tool Kit Click here and download it now
June 5th, 2012 3:47pm

Thanks Naomi, the duplicates appear in the csv format, other formats work fine.
June 6th, 2012 3:51am

How big is the report (how many rows) and are you on the latest SP? It can be a bug, try searching if this problem was already reported.For every expert, there is an equal and opposite expert. - Becker's Law My blog
Free Windows Admin Tool Kit Click here and download it now
June 6th, 2012 9:05am

Hi Sogalexis, I have tried to reproduce the issue in my test environment, however, everything goes well. Could you elaborate the design structure of the report for further analysis? If possible, please capture a screenshot of the issue and upload a sample project to skydrive.live.com. This will be helpful for us to reproduce the issue and help you out. If you export the report from Report Designer, I suggest that you deploy the report to report server and export the report from report manager to check the result. Meanwhile, I suggest that you try Naomis suggestion to update your Reporting Services. You can get the SQL Server versions information from the link below: Microsoft SQL Server 2008 R2 Builds If you have any questions, please feel free to let me know. Regards, Mike Yin
June 10th, 2012 7:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics