Problem in exporting SSRS report to CSV format

Question

I have many SSRS reports, and all are having same issue while exporting data into CSV files. (Upgraded from VS-2005 to VS-2013)

I have some GROUP data on header while displaying the data based on condition like shown in below image:

While exporting Data into CSV format, their header data also getting download along with table-grid data. just like shown in below image (yellow shaded)

I actually want to merge those header columns with the actual data row, like shown in below image: (Yellow shaded)

EDITED:

I have found one solution to remove Header values from CSV. As setting the DataElementOutput to NoOutput (Shown in below image)

But still, not able to merge those header values into Data-Grid. Thank you in advance

Answer 1

Based on the following official documentation:

• Breaking Changes in SQL Server Reporting Services

Redesigned CSV Data Renderer

In earlier versions of Reporting Services, when you exported a report to a CSV file format, the data was formatted in a way that preserved the way the data appeared on the report page. For matrix data regions, this resulted in a data format that was inconvenient to import into other applications in order to continue to work with the data.

In this release, when you export a report to a CSV file, you can choose between two supported formats: Default mode and Compliant mode. Default mode is optimized for Excel. Compliant mode is optimized for third-party applications.

The earlier format for CSV files is no longer available. However, for reports that do not use matrix data regions, you can use Compliant mode to get a file format closest to the earlier CSV file format.

It looks like that the SSRS 2005 CSV renderer has gone through major changes in SSRS 2008 R2 with the support for new features.

Workaround

Check the following question, were they provided an extension to reporting services that add the old csv renderer:

• Force SSRS 2008 to use SSRS 2005 CSV rendering

References and helpful links

• MSDN - How to force SSRS 2008R2 to use the SSRS 2005 CSV rendering mode
• Reporting Service 2008 - CSV export
• How do I export a SSRS matrix to CSV without losing the structure?