Font Color Problem upon export to excel. -- sql server reporting services

bench_five NO[at]SPAM yahoo.com
8/24/2004 8:03:24 PM

I am implementing an expression in the color of the font I am using
for a certain textbox in my report. This is the expression I am using
for the color property: =IIF(
Fields!Plan_Approval_Deadline_Count.Value < 0,"Red","Black"). In
preview and upon viewing the report on the report manager, the
expected result is displayed. Meaning if
Fields!Plan_Approval_Deadline_Count.Value is less than zero it is
displayed in red font else it is rendered in black font.

The problem is, upon export to excel these colors are not maintained.
All entries are displayed in either red color only or black color
only, instead of combination of both depending if the expression is
satisfied. We also noticed the display of color somehow depends on the
first entry. If the first entry should be in red font, all entries
will be red. Same scenario when the first entry should be black. But
we are not sure if it is really based on that.

But upon export to Acrobat (PDF) file, the font colors are maintained.

I hope you can advice me on this matter and any help will be greatly
appreciated.

gabi100 NO[at]SPAM gmail.com
9/22/2004 8:55:11 AM

I've the same behavior. Any Idea??

[quoted text, click to view]

LanceHunt
12/7/2004 1:15:06 PM

This is definitely a bug in the Excel Renderer.

Has anyone had luck trying to get this format to export as an Excel function?

[quoted text, click to view]

sjeffrey NO[at]SPAM gmail.com
1/4/2005 12:02:17 PM

Place an expression in the BackgroundColor property for text boxes that
have an expression in the Color property. We wanted all of our
background colors to be transparent so used the expression

="Transparent"

This work around was provided to us by Microsoft. Some how the Color
property is dependent on the BackgroundColor property.

This issue is known but we won't see it fixed until SQL Server 2005 is
released.

bench
1/5/2005 2:13:16 AM

We have succesfully used the workaround... Thanks a lot for sharing! :)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Font Color Problem upon export to excel.