SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Background Color in SSRS based on column condition
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

210 Posts

Posted - 03/04/2014 :  02:40:04  Show Profile  Reply with Quote


I have created one report in Ssrs(2008).one my column column is Empsal,
we need to change the background color based on empsal colukn(if empsal <5000)

how to make these changes in ssrs reports

if anybody know pls guide on the same

Posting Yak Master

103 Posts

Posted - 03/06/2014 :  15:22:42  Show Profile  Reply with Quote
Go to cell's properties in the property window.You will see background property.Just use this expression in the background property--(for eg for green background)

=IIF(Fields!empsal.Value<5000,"Green","No Color")
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000