Enabling Tab Delimited Exports in SQL Server 2008 R2

9 Oct


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">
 <Name Language="en-US">TAB delimited</Name>
 <FieldDelimiter>	</FieldDelimiter>

Save the…

View original post 92 more words

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: