How can I export my reports to tab delimited csv file?
How can I export my reports to tab delimited csv file? thanks, Gok
October 21st, 2010 1:13am

Hello, you can modify the rsreportserver.config file on the report server to use a tab as delimter instead of the default comma. However this will change the delimiter for everything on that report server ofcourse so you may want to add a separate extension. Follow this link for specifics: http://msdn.microsoft.com/en-us/library/ms155365.aspx
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 2:52am

Thanks but I am not using 2008. I have MS Sql server 2005. is it still possible?
October 21st, 2010 3:38am

You may run into issues if you really are trying to create a tab delimited csv file. A csv is a COMMA seperated values file and is treated differently by some apps than standard .txt files which can of course have pretty much any type of delimeterRgds Geoff
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 5:24am

Is there any example of that? I really need someone to tell me this step by step
October 21st, 2010 5:29am

Hi Gok, Nehemiah is right, you can modify the CSV rendering extension in the rsreportserver.config file (by default, it is stored at C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer) like this: <Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"> <OverrideNames> <Name Language="en-US">PIPE Delimited CSV</Name> </OverrideNames> <Configuration> <DeviceInfo> <FieldDelimiter>|</FieldDelimiter> </DeviceInfo> </Configuration> </Extension> see http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d79845a8-17fb-4ec6-b121-2c40cf466d73 for more details, and open http://msdn.microsoft.com/en-US/library/ms155365(v=SQL.90).aspx for CSV device information settings. We use the "FieldDelimiter" setting in the configuration file. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 10:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics