IIF() with four checkboxes of datatype bit not working

  • 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","")

  • The problem was my join b/n the two tables.  Needed Left Outer to solve the issue.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply