Enabling Tab Delimited Exports in SQL Server 2008 R2

9 Oct

seanmkrause

There are many posts and resources available on the web with instructions for accomplishing this, but I found most to be either incomplete or inaccurate.

The solution involves editing the rsreportserver.config file.  This can be found in the ReportServer installation folder (ex: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer).  I would strongly suggest making a copy of the file first.  While odds are you won’t mess anything up, if you accidentally copy over some existing code or a cat walks across your keyboard while you are hitting Save…ouch!

After making a copy, open the file in Notepad or your favorite text editor.

In the “Render” section (about half-way down the file) simply insert the following code.  I, myself, inserted it after the “CSV” code,  but anywhere between the Render tags should be dandy.

<Extension Name="TAB" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
 <OverrideNames>
 <Name Language="en-US">TAB delimited</Name>
 </OverrideNames>
 <Configuration>
 <DeviceInfo>
 <FieldDelimiter>	</FieldDelimiter>
 <UseFormattedValues>False</UseFormattedValues>
 <NoHeader>False</NoHeader>
 <FileExtension>csv</FileExtension>
 </DeviceInfo>
 </Configuration>
 </Extension>

Save the…

View original post 92 more words

Advertisements

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

%d bloggers like this: