Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : Render to CSV without Header


gdjoshua
6/6/2006 7:12:02 AM
How exactly do you do this. I read another post on this forum and it talked
about setting a parameter in the device info... Where is the device
Chris Baldwin [MSFT]
6/7/2006 10:48:09 AM
DeviceInfo settings for the CSV renderer can be found here:

http://msdn2.microsoft.com/en-us/library/ms155365.aspx

NoHeader is the one you're looking for.

Best,
-Chris
SQL Server Reporting Services


[quoted text, click to view]

gdjoshua
6/8/2006 12:11:02 PM
Yes, but were are these settings configured..... in a config file on the web
server?

Joshua



[quoted text, click to view]
Chris Baldwin [MSFT]
6/8/2006 5:00:14 PM
You can set DeviceInfo params on the URL, when rendering with the SOAP API,
and in RS2005 they can be set in the server configuration file.

Please refer to this doc page for more info:

http://msdn2.microsoft.com/en-us/library/ms155397(sql.90).aspx

Best,
-Chris
SQL Server Reporting Services

[quoted text, click to view]

Edgar
8/7/2006 7:23:02 AM
Hi Chris,

I am dealing with this same issue, but in RS 2000.
Do you mean with your last answer that it is not possible to change the
RSReportServer.config file for RS 2000?

If so, what other method do you recommend to accomplish this?


--
Thanks,

Edgar


[quoted text, click to view]
Edgar
8/10/2006 8:43:02 AM
I already figured this out.

It is not possible to change the RSReportServer.config file for RS 2000.

However you can call the report by URL or Web service call and specify the
NoHeader property. &rc%3aNoHeader=True


Here is an example:

http://OurServer/ReportServer?%2fReportFolderName%2fRpt_402_StockList&rs%3aCommand=Render&rs%3aFormat=CSV&rc%3aReplacementRoot=http%3a%2f%2fOurServer%2fReports%2fPages%2fReport.aspx%3fServerUrl%3d&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Report&rc%3aNoHeader=True

--
Thanks,

Edgar


[quoted text, click to view]
AddThis Social Bookmark Button