We help IT Professionals succeed at work.
Get Started

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

rm103
rm103 asked
on
1,588 Views
Last Modified: 2016-05-31
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
Data Engineer
Top Expert 2014
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE