So you are trying to modify the Reporting Services CSV export behavior. This article will outline two specific behavior changes:
By default Reporting Services exports a CSV file encoded as Unicode and contains a header record. Lets start with turning off the header record.
NOTE: make a backup of any config file prior to making any modifications.
-
First determine the Instance ID of the Report Server for which you want to make the change. You can do this by opening the Reporting Services Configuration Manager: All Programs - Microsoft Visual Studio 2005 - Configuration Tools
Then connect to the appropriate instance. With server status selected on the left you will see the Instance properties. The Instance ID will be used in locating the config file which needs to be changed.
-
Locate and open the rsreportserver.config file with a text editor. C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\rsreportserver.config
Replacing my MSSQL.2 with your Report Server Instance ID.
-
Locate the config section: <Configuration><Extensions><Render>
-
Find the <Extension> config entry.
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport, Microsoft.ReportingServices.CsvRendering" />
-
Extension default behaviors can be modified by making appropriate entries in the device information settings. So to exclude the header row from the output:
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport, Microsoft.ReportingServices.CsvRendering">
<DeviceInfo>
<NoHeader>true</NoHeader>
</DeviceInfo>
</Extension>
-
So now if you want to also change the encoding to ASCII simple add the Encoding device information setting:
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport, Microsoft.ReportingServices.CsvRendering">
<DeviceInfo>
<NoHeader>true</NoHeader>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Extension>
-
Save the file.
There are also other device information settings for the CSV Rendering Extension. You can change the Field Delimiter, Record Delimiter, change the file Extension and more. Here are the CSV Device Information Settings.
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5