SSRS 2008 R2 tab delimited export with quote qualifiers

Question

<Extension Name="TAB" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
	<OverrideNames>    
		<Name Language="en-US">TAB (tab delimited)</Name>    
	</OverrideNames>   
	<Configuration>
		<DeviceInfo>
			<Encoding>ASCII</Encoding>
			<Qualifier>"</Qualifier>
			<FieldDelimiter xml:space="preserve">&#09;</FieldDelimiter>
			<UseFormattedValues>False</UseFormattedValues> 
			<NoHeader>False</NoHeader>
			<FileExtension>txt</FileExtension> 
		</DeviceInfo>
	</Configuration>
</Extension>

I have the above code inserted into my rsreportserver.config file and have restarted the service. I get a tab delimited output but I want quotes wrapped around every data element and it is not doing that. What do I need to do to get:

"ABC"	"1"	"2012-01-01"	"Test"

Answer 1

Hello,

In Reporting Services, the qualifier only goes into effect if your data has either qualifier (where it gets double-qualified), the record delimiter, or the field delimiter. This behavior of the Qualifier DeviceInfo is design. Please refer to the book online: CSV Device Information Settings

To work around this issue, you can try to set the <Qualifier> to "false" and specify the fields in your report with quotes by following expression:
=IIF(Left(CStr(Fields!fieldvalue.Value),1)=””””, Fields!fieldvalue.Value,””””& CStr(Fields!fieldvalue.Value)&””””)

The following thread is about the same issue, please take as reference.
http://social.msdn.microsoft.com/Forums/en-us/sqlreportingservices/thread/4b4724a0-9837-4f8c-8077-79faeb867110
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a34a5cda-b685-45ac-babd-d712e3d3e6fc

Regards,
Fanny Liu

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Fanny Liu
TechNet Community Support