Conditional Format Field Background

Question

Conditional Format Field Background

kabolick

SSC Eights!

Points: 900
More actions
January 7, 2009 at 3:34 pm

#217311

In the Visual Studio 2008 (ver 9.0) Business Intelligence Development Studio report designer I have the option to conditionally format a field's background color based on the value of the field. My client has Visual Studio 2005 (ver 8.0). In this version, I am unable to provided conditional formatting of the field's background color. I do not have the option to apply a function to determine the background color. Does anyone know how to conditionally format the background color of a field?
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

UnionAll SSCrazy Points: 2102 More actions · Answer 1

I believe you will have this feature with VS 2005 aswell.

If you want to format the background color based on the condition, right click on the item you want to format go to properties, in the properties pane look for background color and click the eclipse button.

Here specify the expression, the 'iif' statement.

I think this should work.

LMK if you already did this.

Regards,

denglishbi SSCrazy Eights Points: 8831 More actions · Answer 2

Yeah, nothing has changed as far as being able to use an expression to control this property value. If you are doing something different that does not permit this then please provide the steps that you are taking to set this property along with the expression you are using.

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com

kabolick SSC Eights! Points: 900 More actions · Answer 3

Thanks for the replies. I actually found it. The option was just located in a different place on the 2005 version. I had done some research online for heat maps, conditional formatting, etc. and there was a lot of solutions using a C# developed solution, etc. that had me believing something was missing in 2005. Thanks again.

pravat SSC-Addicted Points: 410 More actions · Answer 4

Hi SSRS Rookies...

How did u do it..I am having same problem in SSRS 2008 and havent been able to do it...

any help will be appreciated..

Thanks

H4K Hall of Fame Points: 3374 More actions · Answer 5

Hi,

1) Select the field to which you want to add conditional background color and press F4 to open the properties window.

2) Then CLICK on the dropdown box next to BackgroundColor and select Expression.

3) In the new window, Write following expression :

=iif(value = something, "Black", "Red")

BackgroundColor will be "Black" if value = something condition is true

else it will be "Red"

BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI

H4K Hall of Fame Points: 3374 More actions · Answer 6

Hi,