SSRS Report Builder - Export to CSV issue; Double Quotes exist for each record.
We have a report that is scheduled to produce a CSV file.
This file is consumed by another application and requires specific formatting in order to successfully process the file.
The following entry has been configured within the 'rsreportserver.config' file:
<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-AU"> CSV No Header</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<NoHeader>true</NoHeader>
<Extension>CSV</Extension>
<Encoding>UTF-8</Encoding>
<Qualifier></Qualifier>
</DeviceInfo>
</Configuration>
</Extension>
The file that is being generated from this contains double quotes at the start and end of each record (see below).
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
"DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY"
"180603,06/06/2018,AB,123,A,AB,123456789,-1234.56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TEAMJNL,123"
The output we need is shown below:
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY
180603,06/06/2018,AB,123,A,AB,123456789,-1234.56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TEAMJNL,123
Please advise how to fix this.
<FieldDelimiter>;</FieldDe