Andrew Cowan
asked on
SSRS Report Builder - Export to CSV issue; Double Quotes exist for each record
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.ReportingS ervices.Re ndering.Da taRenderer .CsvReport ,Microsoft .Reporting Services.D ataRenderi ng">
<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,DCLR ENTITY,DEN TITYPE,LLD GCODE,LACC NBR,LAMOUN T1,LNARR1, LNARR2,LNA RR3,LPRESC STAT,LGSTT YPE,LGSTRA TECODE,BIM PNAME,BCLR ENTITY"
"180603,06/06/2018,AB,123, A,AB,12345 6789,-1234 .56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TE AMJNL,123"
The output we need is shown below:
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
DREF1,DDATE1,DSOURCE,DCLRE NTITY,DENT ITYPE,LLDG CODE,LACCN BR,LAMOUNT 1,LNARR1,L NARR2,LNAR R3,LPRESCS TAT,LGSTTY PE,LGSTRAT ECODE,BIMP NAME,BCLRE NTITY
180603,06/06/2018,AB,123,A ,AB,123456 789,-1234. 56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TE AMJNL,123
Please advise how to fix this.
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.ReportingS
<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,DCLR
"180603,06/06/2018,AB,123,
The output we need is shown below:
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
DREF1,DDATE1,DSOURCE,DCLRE
180603,06/06/2018,AB,123,A
Please advise how to fix this.
ASKER
We ended up finding an external solution to strip the quotes out of the csv file.
Although this is not be a permanent fix, we will take the suggestion to add FieldDelimiter>;</FieldDel imiter> above the noheader line when we begin testing again.
Thanks.
Although this is not be a permanent fix, we will take the suggestion to add FieldDelimiter>;</FieldDel
Thanks.
Try including these lines
<FieldDelimiter>|</FieldDe limiter>
<ExcelMode>False</ExcelMod e>
<FieldDelimiter>|</FieldDe
<ExcelMode>False</ExcelMod
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
<FieldDelimiter>;</FieldDe