Render to CSV without Header

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gdjoshua - 06 Jun 2006 15:12 GMT

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
info??????? Any help would be greatly appreciated...

Reply to this Message

Chris Baldwin [MSFT] - 07 Jun 2006 18:48 GMT

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

> 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
> info??????? Any help would be greatly appreciated...

Reply to this Message

gdjoshua - 08 Jun 2006 20:11 GMT

Yes, but were are these settings configured..... in a config file on the web
server?

Joshua

> DeviceInfo settings for the CSV renderer can be found here:
>
[quoted text clipped - 10 lines]
> > about setting a parameter in the device info... Where is the device
> > info??????? Any help would be greatly appreciated...

Reply to this Message

Chris Baldwin [MSFT] - 09 Jun 2006 01:00 GMT

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

> Yes, but were are these settings configured..... in a config file on the
> web
[quoted text clipped - 16 lines]
>> > about setting a parameter in the device info... Where is the device
>> > info??????? Any help would be greatly appreciated...

Reply to this Message

Edgar - 07 Aug 2006 15:23 GMT

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?

Signature

Thanks,

Edgar

> 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.
[quoted text clipped - 27 lines]
> >> > about setting a parameter in the device info... Where is the device
> >> > info??????? Any help would be greatly appreciated...

Reply to this Message

Edgar - 10 Aug 2006 16:43 GMT

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

Signature

Thanks,

Edgar

> Hi Chris,
>
[quoted text clipped - 35 lines]
> > >> > about setting a parameter in the device info... Where is the device
> > >> > info??????? Any help would be greatly appreciated...

Reply to this Message