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?
>
>