topic Re: Export paginated Report to tsv in Report Server

Export paginated Report to tsv

codegirl — Thu, 25 Jan 2024 20:42:26 GMT

How can I export a paginated report to tsv with a tab delimiter? In SSRS I could add an extension to the config file but that doesn't seem to work anymore. The option still shows but the file has a comma instead of a tab for it's delimiter.

Re: Export paginated Report to tsv

d_gosbell — Fri, 26 Jan 2024 01:04:45 GMT

editing the config file definitely still works. Below is the config I'm using (note that there is an acutal TAB character in the FieldDelimiter)

<Extension Name="TAB" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering" > <OverrideNames> <Name Language="en-US">TSV (Tab Separated)</Name> </OverrideNames> <Configuration> <DeviceInfo> <SuppressLineBreaks>true</SuppressLineBreaks> <FileExtension>tsv</FileExtension> <FieldDelimiter xml:space="preserve"> </FieldDelimiter> </DeviceInfo> </Configuration> </Extension>

Re: Export paginated Report to tsv

codegirl — Fri, 26 Jan 2024 16:00:45 GMT

I did not have my Field Delimiter set like yours. It worked after changing the field delimiter to match yours. I also had to stop reporting services and restart it using the Report Server Configuration Manager. Restarting the server did not work.