Export paginated Report to tsv

[codegirl]

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.

[d_gosbell · Accepted solution]

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>

[codegirl]

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.