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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2005-07-29 : 14:25:24
|
| There are four checkboxes (datatype of bit), and it the user hasn't checked any of the four, then I throw an "X", else it needs to be blank (if they've checked 1, 2, or even 3 of the boxes). I'm getting an "X" every time, even for a record that's got two checkboxes checked.The expression is as follows:=IIF((Fields!Cost_Load_Report.Value = 0) and (Fields!Spend_Plan.Value = 0) and (Fields!Resource_Load_Report.Value = 0) and(Fields!Target_File_Schedule.Value = 0),"X","") |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2005-07-29 : 14:51:26
|
| The problem was my join b/n the two tables. Needed Left Outer to solve the issue. |
 |
|
|
|
|
|
Expression w/ four checkboxes of bit datatype