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 |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2009-02-04 : 13:09:48
|
| I was wondering if there was a way to write an expression in one of the cells to say....=IIF(Fields!Note.Value = AF then Field!MAS90AF.Value)=IIF (=Fields!Note.Value = NG then Field!MAS90.Value)Can that be done or not? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-04 : 13:17:08
|
| YUP. Its possible=IIF(Fields!Note.Value = AF, Field!MAS90AF.Value,your false condition here)=IIF (Fields!Note.Value = NG,Field!MAS90.Value,your false condition here) |
 |
|
|
werhardt
Constraint Violating Yak Guru
270 Posts |
Posted - 2009-02-04 : 13:37:26
|
| Oh, this is really great then! Soo where it says "your false condition here", can that just be my field that needs to be added? Because Field!MAS90AF or Field!MAS90 can be all types of different numbers.=IIF(Fields!Note.Value = AF, Field!MAS90AF.Value,your false condition here)=IIF (Fields!Note.Value = NG,Field!MAS90.Value,your false condition here) |
|
|
|
|
|
|
Microsoft Visual Studio Expression