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