Excluding Export Options on Report

In the rsreportserver.config there is a <ExcludedRenderFormats> element, which allows you to list the rendering formats that are excluded from the export option for all reports.

Is this the only way you can change this? i.e. can you change this through Management Studio or Report Manager, and also can you exclude the export options for a single report rather than having to do it for all reports?

Thank you

Hi,

no this is a serverwide property which can only be administered through the "XML-Interface" <:-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||To confirm the "XML-Interface" being the rsReportServer.config file|||Yes.sql

Excel Rendering Problem w/ SP1

Since installing SP1, RS does not render color information to Excel
correctly. The report in question renders to all other formats correctly. The
error occurs on a variance report where individual cells of a table have
color dynamically assigned based on the variance values (green = good, red = bad). Instead of formatting the individual cell based on the logic embedded
in the report, the entire column retains the color code of the first column.
Any help?Hi,
I had a problem while rendering to Excel before the SP1.
After SP1 is installed Excel rendering works fine.
Eralper
http://www.kodyaz.com
"SD Sills" wrote:
> Since installing SP1, RS does not render color information to Excel
> correctly. The report in question renders to all other formats correctly. The
> error occurs on a variance report where individual cells of a table have
> color dynamically assigned based on the variance values (green = good, red => bad). Instead of formatting the individual cell based on the logic embedded
> in the report, the entire column retains the color code of the first column.
> Any help?|||Same problem here .
Did you find a solution ?
"SD Sills" <SDSills@.discussions.microsoft.com> wrote in message
news:D74E38BA-08AC-4D7F-B54F-E4F5F9E7DE7B@.microsoft.com...
> Since installing SP1, RS does not render color information to Excel
> correctly. The report in question renders to all other formats correctly.
> The
> error occurs on a variance report where individual cells of a table have
> color dynamically assigned based on the variance values (green = good, red
> => bad). Instead of formatting the individual cell based on the logic
> embedded
> in the report, the entire column retains the color code of the first
> column.
> Any help?|||I'm using the below expression for background information of Active column
in my report. I want to see background green if the record is active, red
otherwise
so my expression for BackgroundColor is :
=iif(Fields!Active.Value="True","Green","Red")
Active field has a boolean type in SQl server.
I'm using MS Excel version 2003 SP1, 11.6355.6360 and colors of the exported
excel document is correct.
Excel version may cause rendering problems. I was having one with version 9.
Eralper
http://www.kodyaz.com
"Tudor VAsile" wrote:
> Same problem here .
> Did you find a solution ?
> "SD Sills" <SDSills@.discussions.microsoft.com> wrote in message
> news:D74E38BA-08AC-4D7F-B54F-E4F5F9E7DE7B@.microsoft.com...
> > Since installing SP1, RS does not render color information to Excel
> > correctly. The report in question renders to all other formats correctly.
> > The
> > error occurs on a variance report where individual cells of a table have
> > color dynamically assigned based on the variance values (green = good, red
> > => > bad). Instead of formatting the individual cell based on the logic
> > embedded
> > in the report, the entire column retains the color code of the first
> > column.
> >
> > Any help?
>
>