DeviceInfo in .config file (SQL RS 2000)

Hi,

I am trying to change the default behavior of .CSV Renderer, by specifying NoHeader=false in the RSReportServer.config file. The exact info specified is here:

<Configuration>
<DeviceInfo>
<NoHeader>true</NoHeader>
</DeviceInfo>
</Configuration>

Unfortunately even after restarting the reporting services, the changes don't apply and i still get 'Header' as part of the .CSV export.

Would appreciate if anyone could guide me as what is wrong here..

thanks

sreeram.

Ram,

This feature (default DeviceInfo settings in config file) was implemented in RS2005. It is not in RS2000.

Determining Report Format from expression

I would like to be able to check format to be running as, so I can make
some columns and fields invisible if run as excel or CSV etc.
Is this possible? I dont see a way at hitting render format from Report!
object.
Thanks.On May 15, 11:55 am, Weston Weems <wweemsBLH-BLAH@.G_NOSPAM_MAIL.com>
wrote:
> I would like to be able to check format to be running as, so I can make
> some columns and fields invisible if run as excel or CSV etc.
> Is this possible? I dont see a way at hitting render format from Report!
> object.
> Thanks.
As far as I know, this functionality is not available. That said, you
can create a custom application that controls the export options and
the fields/columns that are displayed. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Actually you might be onto something with that. I've already managed to
whip up my own dynamic report viewer in asp.net and it works quite
well... I will just inject a hidden parameter called format... then i
can use the format in the queries etc =)
That'll work great for me.
EMartinez wrote:
> On May 15, 11:55 am, Weston Weems <wweemsBLH-BLAH@.G_NOSPAM_MAIL.com>
> wrote:
>> I would like to be able to check format to be running as, so I can make
>> some columns and fields invisible if run as excel or CSV etc.
>> Is this possible? I dont see a way at hitting render format from Report!
>> object.
>> Thanks.
>
> As far as I know, this functionality is not available. That said, you
> can create a custom application that controls the export options and
> the fields/columns that are displayed. Sorry that I could not be of
> greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>