SSRS reports can be exported in different format. Default text format is comma separated values. If we need different format we can do so by updating RSReportServer.config file.
On SSRS server add following
entry to file D:\Program Files\Microsoft SQL
Server\MSRS11.MSSQLSERVER\Reporting
Services\ReportServer\RSReportServer.config.
The entry below needs to be
added to the <Render> node:
<Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">Text (Pipe Delimited)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter>|</FieldDelimiter>
<FileExtension>txt</FileExtension>
</DeviceInfo>
</Configuration>
</Extension>
