Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Conditional Format Field Background Expand / Collapse
Author
Message
Posted Wednesday, January 07, 2009 3:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, September 20, 2009 6:29 PM
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.
Post #631957
Posted Wednesday, January 07, 2009 3:40 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 9:13 PM
Points: 190, 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,
Post #631962
Posted Thursday, January 08, 2009 7:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 22, 2013 7:25 AM
Points: 347, Visits: 1,344
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
Post #632357
Posted Thursday, January 08, 2009 8:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, September 20, 2009 6:29 PM
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.
Post #632428
Posted Wednesday, September 08, 2010 8:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 20, 2010 8:08 PM
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
Post #982380
Posted Thursday, September 09, 2010 12:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 2:21 PM
Points: 132, Visits: 557
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
Post #982843
Posted Thursday, September 09, 2010 12:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 2:21 PM
Points: 132, Visits: 557
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
Post #982844
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse