Export Tab Delimited text file in SSRS 2008 R2

Locate rsreportserver.config in the server, and add the below lines of code

Code Snippet
  1. <ExtensionName=TABType=Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering>
  2.                 <OverrideNames>
  3.                      <NameLanguage=en-US>TAB (Tab Delimited Text File)</Name>
  4.                 </OverrideNames>
  5.                 <Configuration>
  6.                           <DeviceInfo>
  7.                                <FieldDelimiterxml:space=preserve>    </FieldDelimiter>
  8.                            <UseFormattedValues>False</UseFormattedValues>
  9.                                <NoHeader>False</NoHeader>
  10.                       <FileExtension>Txt</FileExtension>
  11.                           </DeviceInfo>
  12.                       </Configuration>
  13.             </Extension>

I added it right below CSV extension

I did a few things with the TAB extension, I named the Extension “TAB”, I Named in  TAB (Tab Delimited Text File) this the name that is displayed in the reports webpage when you click the export option


I wanted the file extension to be .txt, so I mention <FileExtension>Txt</FileExtension>
I wanted the Column Header in the tab delimited file so <NoHeader>False</NoHeader>


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s