Friday, November 30, 2012 8:15 PM
<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">	</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"
Monday, December 03, 2012 2:22 AMModerator
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.
TechNet Community Support