How to modify Reporting Services CSV export Behavior

So you are trying to change the Reporting Services CSV export behavior.  This article will outline two specific behavior changes:

  • How to turn off exporting of the header record
  • How to change the encoding to ASCII

By default Reporting Services exports a CSV file encoded as Unicode and has a header record.  Lets start with turning off the header record.

NOTE: make a backup of any config file before making any changes.

  1. First find 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 proper instance.  With server status selected on the left you will see the Instance properties.  The Instance ID is used in locating the config file which will be changed.
  2. 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.
  3. Locate the config section:
  4. Find the <Extension> config entry.
  5. Extension default behaviors is modified by making proper entries in the device information settings.  So to exclude the header row from the output:
  6. So now if you want to also change the encoding to ASCII simple add the Encoding device information setting:
  7. 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.

You May Also Like

About the Author: Joseph Caudill

Leave a Reply

Fork me on GitHub