SSRS Report Format options

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>