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 |
|
malachi151
Posting Yak Master
152 Posts |
 Posted - 2012-11-20 : 16:36:40
|
My problem is that I have some condition formatting that is itself condition depending on the column.I used something like the following expression:=IIF(Fields!X.Value="ABC", Red, Green) The problem is that in a Matrix when the value for a cell is NULL, then the value for the field that I'm checking is also NULL, so it can't be checked.Is there a way do condition formatting based directly on a check of the ordinality of the column, i.e. something like IIF(Columns.Index = 0, X, Y), etc.?--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2012-11-26 : 09:22:57
|
| I ended up solving this a different way. I created two different column groups and put filters on them, then put different conditional formatting on the two columns.--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
 |
|
|
|
|
|
How to determine column in Tablix expression?