Export a CSV without headers in SSRS

In SSRS report we have an option to export report to many formats like Excel, CSV, PDF, Word and so on. In case of CSV export, we will get all the column headers in exported file. Some time we need CSV without column header. Below is the solution to get this done.

à Open rsreportserver.config file under C:\Program Files\Microsoft SQL Server\{INSTANCE}\Reporting Services\ReportServer in reporting server. à Add below mentioned XML tags after <Extension Name="CSV"... />

<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">

<OverrideNames> <Name Language="en-us"> CSV No Header</Name>

</OverrideNames> <Configuration> <DeviceInfo>

<NoHeader>true</NoHeader> </DeviceInfo>

</Configuration> </Extension>

à Save the file. After this changes, run one report. Under export option in that report, you must be able to see the option 'CSV No Header' as in below image(a). And exported data will not contains any headers.