December 22, 2011 at 10:21 am
I have 2 questions. Please forgive me if I didn't put this question in the right section but I didn't see an SSRS section.
I've read 3-4 web sites that stated that one would have to add the following code to the rsreportserver.config in order to get a pipe delimited option when trying to export...
<Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">TXT (Pipe delimited)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter>|</FieldDelimiter>
<Extension>txt</Extension>
</DeviceInfo>
</Configuration>
</Extension>
I've added that code and have made minor changes to it because other websites had slightly different code. Nothing is working. I run a report and click on the drop down menu and I just can't seem to get the pipe delimited option. This is of course after restarting reporting services. I've also rebooted but it still isn't taking. What am I missing?
My next question is what XML code would I add so that there are quotes around the data? Ie...
"123456"|"Smith"|"Clyde"|"CO"
I've read this but it's not apparently clear to me as to what I'd need to add...
http://msdn.microsoft.com/en-us/library/ms155365(SQL.90).aspx
TIA,
John
December 22, 2011 at 10:27 am
J Moore (12/22/2011)
I have 2 questions. Please forgive me if I didn't put this question in the right section but I didn't see an SSRS section.My next question is what XML code would I add so that there are quotes around the data? Ie...
"123456"|"Smith"|"Clyde"|"CO"
I've read this but it's not apparently clear to me as to what I'd need to add...
http://msdn.microsoft.com/en-us/library/ms155365(SQL.90).aspx
TIA,
John
Wait, would I add...
<Qualifier>"</Qualifier>
...to the config file to put the data in quotes? If so, I'm good on the second question. I just need to get the option for the pipe delimited to show up as an export option.
December 22, 2011 at 11:50 am
J Moore (12/22/2011)Wait, would I add...
<Qualifier>"</Qualifier>
...to the config file to put the data in quotes? If so, I'm good on the second question. I just need to get the option for the pipe delimited to show up as an export option.
Ok. I got the Pipe option to finally work. Before it was acting like it wasn't even looking at any of the changes in the rsreprotserver.config. My problem now is I can't get the qualifier to work. Here's what I have in my config file...
<Extension Name="Pipe" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-US">Pipe (Quote qualifier)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter>|</FieldDelimiter>
<NoHeader>true</NoHeader>
<Qualifier>"</Qualifier>
<Extension>csv</Extension>
</DeviceInfo>
</Configuration>
</Extension>
I really don't want to have to add quotation marks in my sql script....or any other script that needs this same format.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply