Trying to use RSReportServer.config to handle .CSV

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

Development Tools

Reporting Services Development

Trying to use RSReportServer.config to handle .CSV

Author

Topic

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2007-04-10 : 15:08:04

We are using SSRS 2000.

I can make the .csv file format correctly with blank lines when I put in the URL a suffix of:

..&rs:Format=CSV&rc:SuppressLineBreaks=True

I wanted to try to change this in the config file and have the RSreportServer.config file @:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer

I've made the following changes and restarted both IIS and the Reporting Services service itself and no luck:


<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
<SuppressLineBreaks>True</SuppressLineBreaks>
</DeviceInfo>
</Configuration>
</Extension>

dsentelle
Starting Member

2 Posts

Posted - 2007-05-10 : 10:12:24

I'm having exactly the same problem. I've renamed the extensions and everything, but the names don't change. I'm glad to find out you are able to pass the parameters by URL, that indicates to me that there's a syntax difference between RS2000 and RS2005 that I've missed somewhere.

quote:
Originally posted by bubberz

We are using SSRS 2000.

I can make the .csv file format correctly with blank lines when I put in the URL a suffix of:

..&rs:Format=CSV&rc:SuppressLineBreaks=True

I wanted to try to change this in the config file and have the RSreportServer.config file @:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer

I've made the following changes and restarted both IIS and the Reporting Services service itself and no luck:


<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
<SuppressLineBreaks>True</SuppressLineBreaks>
</DeviceInfo>
</Configuration>
</Extension>

dsentelle
Starting Member

2 Posts

Posted - 2007-05-10 : 13:09:21

Bad news, I found this...

[url]http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=964191&SiteID=1[/url]

and it appears those parameters may only be called VIA url. How freakin lame, that should be ANYWHERE on Microsoft's site for reporting services 2000.

I'm wondering how you pass the username, etc, because when I go to the URL I've setup it comes over in HTML format.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources