Reporting Server Export - Space Delimiter

Question

Reporting Server Export - Space Delimiter

deanajacobus

SSC Enthusiast

Points: 186
More actions
March 6, 2015 at 5:56 pm

#305061

I've been researching for some time now and would like to receive some guidance from you.
I've been able to add delimiters to the export or 'Save as' option within the report builder by adding different information into the rsreportserver.config file, such as ; delimiter and 'tab', but I am unable to find anything that would show me how to add a space delimiter to the configuration file. The current configuration i have is as follows, what am I missing?
<Extension Name="TAB" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">TXT (Tab)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter xml:space="preserve"> </FieldDelimiter>
<FileExtension>txt</FileExtension>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="TXT_2" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">TXT (2)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter>;</FieldDelimiter>
<FileExtension>txt</FileExtension>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="TXTSpaceDelimited" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">TXT (Space)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter xml:space="preserve">....... </FieldDelimiter>
<FileExtension>txt</FileExtension>
</DeviceInfo>
</Configuration>
</Extension>
The '.........' portion in the line of <FieldDelimiter xml:space="preserve">....... </FieldDelimiter>
is where i am having issues.
Thank you already for your help!
DJ

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

sql Sarah SSCrazy Points: 2081 More actions · Answer 1

I saw an article about enabling tab delimited reports. In the field delimiter line, they use the ascii code for a tab:

<FieldDelimiter>& # 9 ;</FieldDelimiter> (remove the spaces! I had to put them here because the website was not showing the text without them.)

I would try the ascii code for a space :

<FieldDelimiter>& # 32;</FieldDelimiter> (remove the spaces! I had to put them here because the website was not showing the text without them.)

References to where I found the info:

Enabling tab delimiters -

http://seanmkrause.com/2012/10/09/sql-server-2008-r2-tab-exports/

Ascii Code -

http://www.ascii-code.com/

deanajacobus SSC Enthusiast Points: 186 More actions · Answer 2

Thank you!!! I will definitely try this out right now. I'll let you know if it worked. Again thank you