Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Conditional Format Field Background


Conditional Format Field Background

Author
Message
kabolick
kabolick
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 95
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.
UnionAll
UnionAll
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 637
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
denglishbi
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 1362
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
kabolick
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 95
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
pravat
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 100
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
H4K
SSC-Enthusiastic
SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)

Group: General Forum Members
Points: 135 Visits: 567
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
H4K
SSC-Enthusiastic
SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)

Group: General Forum Members
Points: 135 Visits: 567
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search