Prologika Forums

Teo,

What should i place into the <DeviceInfo><FieldDelimiter></FieldDelimiter></DeviceInfo> section if I want a tab as my delimiter.

I've tried the below example but no go. I've also tried

<![CDATA[&#9;]]> <!-- this is the CDATA section with horizontal tab character hex code -->

<![CDATA[ ]]> <!-- this is the CDATA section with an actual ascii tab character -->

   <Extension Name="TXT1" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
    <OverrideNames>
     <Name Language="en-US">TXT1 (Tab Delimited Text File)
     </Name>
    </OverrideNames>
    <Configuration>
     <DeviceInfo>
      <FieldDelimiter><![CDATA[&#9;]]></FieldDelimiter>
      <Extension>TXT</Extension>
      <Encoding>ASCII</Encoding>
     </DeviceInfo>
    </Configuration>
   </Extension>

I haven't tried this lately, but to my understanding tab characters are not supported in the configuration file but can be passed as parameters to the report URL, such as

http://server/reportserver/?/myreport&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter=%09

If I hear otherwise, I will update this post.

BTW, this will be fixed in SQL Server 2008, where you can set it as follows.  Note the actual “tab” whitespace in the FieldDelimiter value.

<Configuration>

<DeviceInfo>

<FieldDelimiter xml:space="preserve">                </FieldDelimiter>

</DeviceInfo>

</Configuration>