SSRS Report Builder - Export to CSV issue with extra Double Quotes

rm103
rm103 used Ask the Experts™
on
I created a report in SSRS to be used to generate a flat file for the printing of Product Labels in Bartender.  At the top of the report, I have a string of information that needs to be printed exactly as indicated below.  The line with a header of "Yours-" is what is currently displaying when you open the CSV with Note Pad and the line with a header of "Printer-" is what should be printing.  If I open the file in Excel, everything appears to be fine.  The only thing that changes is the Label Format field which is being updated from a SQL Table (it's the extension that ends in .btw).  

Yours-
"%BTW% /F=""\\Sav2008\Sage\Label\MAS_SWK\format\format2.btw"" /D=""<Trigger File Name>"" /p /C=1 /DD /DBTEXTHEADER=3 /R=3 "

Printer-
%BTW% /F="\\Sav2008\Sage\Label\MAS_SWK\format\WMS\WMS_format7.btw" /D="<Trigger File Name>" /p /C=1 /DD /DBTEXTHEADER=3 /R=3
%END%

I found an article online that told me to modify the following information in the rsreportserver.config file but it appears to not have solved the issue.  I need to have the code in there to remove the headers but am not sure about the rest or if I need any additional code to get the "" from showing up when there only should be one ".

      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
      <OverrideNames>
         <Name Language="en-us"> CSV No Header</Name>
      </OverrideNames>
      <Configuration>
         <DeviceInfo>
            <NoHeader>true</NoHeader>
            <ExcelMode>true</ExcelMode>
            <Qualifier></Qualifier>
            <Encoding>ASCII</Encoding>
         </DeviceInfo>
      </Configuration>
      </Extension>
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Developer
Top Expert 2014
Commented:
From a question on connect.microsoft.com
The renderer adds quotes (called "qualifiers") around values that contain the field delimiter character. Since the default field delimiter character in the CSV renderer is a comma, you will see qualifiers around any data value that contains the comma. ... You could change your field delimiter to something different (see DeviceInfo documentation for the CSV renderer) in order to get around this.
In short I'm not sure SSRS is the best way to go. Have you looked into a bulk export directly from SQL?

Author

Commented:
Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial