Export to Tab Delimited TXT - SQL Reporting Services

I am new to Reporting tools. How can I export the output to Tab Delimited TXT. I found some solutions, however, I could not understand how to proceed with them... anybody can explain the solution step by step...

Hi Pradeep,

Try some of these links

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=924133&SiteID=1

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74882

|||

Thanks Sudhir for the reply, however, I need to export the SQL Reporting Services REPORT output to TAB Delimited TXT file.

|||

Hi,

From your description, it seems that you want to change the CSV extension to a Tab delimited output in your reporting service, right?

If so, you should add a new extension line to the RSReportServer.config file to enable the Tab delimited output.

In the config file, you should change the following settings:

1. For tab-delimited report, use
<FieldDelimiter> </FieldDelimiter>

2. For name override, you must specify language attribute:
<Name Language="en-US">TXT (Tab Delimited Text File)</Name>

For more information, see:http://msdn2.microsoft.com/en-us/library/ms156281.aspx

Thanks.