SQL Server Home
Unbalanced Double Quotes " in CSV Generated From Reporting Services 2008
9/23/2010 8:32:00 AM
User(s) can reproduce this bug
I have a data driven subscription which runs a reporting services report and generates the results as a csv file.
One of the field values inlcudes a double quote : Bread Tortilla Flour 10".
In SSRS 2005 this is correctly extracted to the csv as "Bread Tortilla Flour 10""". That is the value is placed in double quotes and the double quote itself is balanced with a second.
In SSRS 2008 this is extracted as "Bread Tortilla Flour 10"" which leaves an unblanced quote and makes the rest of the file unreadable.
Is this a bug - or do we have an incorrect setting. The report has been migrated directly from 2005 to 2008.
SQL Server 2008 SP1
Win2003 Enterprise Server (SP2)
Operating System Language
Steps to Reproduce
Query a text field containing a " in Reporting services 2008 and export to csv
"Bread Tortilla Flour 10""
"Bread Tortilla Flour 10"""
to post a comment.
Please enter a comment.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft