Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mchohan
Starting Member
39 Posts |
 Posted - 2009-10-23 : 05:03:05
|
| HiI've got an annoying issue regarding the matrix column color.I want to color an entire column Grey. I'm dynamically creating my matrix and the column I want grey is : "procedure sub total" column. I've assigned an expression in the backgroundcolor cell as follows:=IIF((isNothing(Fields!value.Value) AND (Fields!colDesc.Value = "Proc Sub Total")), "Silver","White")As you can see I'm checking that the cell isn't Null AND it's equal to my Column then color Grey.However It still seems to color the cells with a value of 0 "White". I've also tried to check that the value is >=0 and it's still not doing it. Any ideas on how I can get the full colum grey?Miteshwww.toastbox.co.uk |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-23 : 06:47:08
|
| For one, I would remove the "IIF((isNothing(Fields!value.Value) AND " because if it is = "Proc Sub Total" then it cannot be nullJohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
mchohan
Starting Member
39 Posts |
Posted - 2009-10-23 : 07:05:03
|
| I have also tried where I only check for "Proc Sub Total" and it still gives the same.Miteshwww.toastbox.co.uk |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-23 : 13:33:16
|
| are you talking about standard matrix subtotal column thats rendered dynamically? |
|
|
|
|
|
|
Dynamic Matrix Column Color