6

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:

enter image description here

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)

enter image description here

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

enter image description here

EDITED:

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

enter image description here

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

Irfan
  • 665
  • 6
  • 29
  • Might just be best to create some new columns and set them as hidden in the regular report. That way, they should export to excel, but wouldn't show up on the regular report. – Steve-o169 Mar 15 '19 at 13:28
  • @Steve-o169: thanks for the suggestion. but actually in my older report in VS2005 from the same settings its working perfectly as i expected. but after upgrading the Report it has stopped working. strange! – Irfan Mar 18 '19 at 00:31
  • @jap_jap - To which version, you have upgraded your reports? – Aftab Ansari Mar 20 '19 at 05:29
  • @Aftab: From VS2005 to SSDT-2012 (in VS2013) I have upgraded – Irfan Mar 20 '19 at 07:48
  • 2
    The csv renderer in SSRS 2005 is no more available since SSRS 2008. I am not sure if you still can export with the same rendering without any third-party extension. – Yahfoufi Mar 21 '19 at 09:07

1 Answers1

3

Based on the following official documentation:

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:

References and helpful links

Community
  • 1
  • 1
Hadi
  • 36,233
  • 13
  • 65
  • 124