CODEWITHSUNDEEP
reporting-servicesssrs-2012
user7933836
user7933836

Reputation: 67

Issue in Exporting SSRS Reports with pivots in to CSV

I have a report in SSRS which I have build using report builder. So the thing is I want to have a pivot on the data and it works fine in the preview also when I export the rendered report into Excel. The issue comes up when I export the report into CSV. I have attached 4 images which will help in understanding my issue. I am using a matrix to build the report which works fine when I export it into Excel.

This is the output of the report when exported into excel. This is the output of the report when exported into csv

Can someone please help me with this?

Thanks

Upvotes: 1

Views: 492

Answers (1)

R. Richards
R. Richards

Reputation: 25151

Unfortunately, that is how the CSV export works. It is not pretty.

More often than not, when it comes to reports that are more than just simple tables of data, the CSV data is almost useless after export.

Your best bet would be to create a report that is a little more friendly toward CSV exports, or avoid exporting to CSV if you don't have to. Excel tends to work much better for most exports.

Upvotes: 1

Related Questions