Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Exporting to pipe-delimited

Author  Topic 

vbwrangler
Starting Member

9 Posts

Posted - 2007-08-08 : 09:27:38
Has any one managed to get Report Manager to have the option to export to pipe delimited? There are documents out there how to do it on SSRS; I need it on Report Manager. Any Suggestions?

DGraham
vbwrangler@yahoo.com

vbwrangler
Starting Member

9 Posts

Posted - 2007-08-08 : 15:54:20
OK so I'm the fisrt to respond to my own link. I have solved part of the problem and still have an issue.

The code below added to the <Render> section the rsReportServer.config made pipe-delimited exports available in Report Manager:

<Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"> <OverrideNames><Name Language="en-US">PIPE Delimited </Name></OverrideNames> <Configuration><DeviceInfo><FieldDelimiter>|</FieldDelimiter> </DeviceInfo></Configuration></Extension>

But I would like the file type to be *.txt rather than .csv the class has that capability I just haven't hit on the right syntax in the above XML. Anybody change a file extensions in the configs?

DGraham
vbwrangler@yahoo.com
Go to Top of Page
   

- Advertisement -