Written by Thomas Harlan, Jim McGrath; Reporting Services Team - iatricSystems
End users are very fond of running reports in SSRS and exporting the results to a variety of formats. Excel is probably the most popular, but invariably there will be other formats needed.
Unfortunately, in SSRS the list of other formats is limited. In particular, a pipe (|) delimited format is not available. But you can, if you are willing to update your SSRS configuration, add this yourself. The following approach has been tested through SSRS 2012. It may work in SSRS 2014+, but we have not yet confirmed it on that platform.
As always, before you update a configuration file, make a backup!
<Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<Name Language="en-US">TXT (Pipe delimited)</Name>
Your users can now export to pipe-delimited text files. You can add other custom delimiters, as needed.
The RSReportServer.config file will need to be checked and/or modified every time SSRS is installed or updated.
If you need more help…
Our Report Writing team can help you fix reports, create new ones, make old ones faster, and much more. Simply reach out to your Iatric Systems Account Executive or our NPR report writing team at firstname.lastname@example.org to discuss how we can help support your team!