Four Checkboxes of Bit Datatype in IIF() not working correctly

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

[498 byte] By [bubberz] at [2007-12-16]
# 1
The problem was my join b/n the two tables. Needed Left Outer to solve the issue.
bubberz at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified