Crystal Reports This should be simple...

Message

   I swear this should be a straight forward formula but I'm hitting a wall.

I have 2 SQL tables; tblServiceOrders & tblReps

tblSerivceOrders.TechAssigned is linked with tblReps.RepID (numbers)

When you mark a service order as "unassigned" the TechAssigned field is 0

There is NOT a record in tblReps with a RepID of 0.

My goal is to group service orders by the assigned tech and also list the unassigned service orders on the report.  So far everything I've tried will not display service orders that are unassigned.

Here are the formulas I've tried:

If isnull({tblServiceOrders.TechAssigned}) then "Unassigned" else {tblReps.FirstName}

or

If {tblServiceOrders.TechAssigned} = 0 then "Unassigned" else {tblReps.FirstName}

or

If ToText({tblServiceOrders.TechAssigned}) = "0" then "Unassigned" else {tblReps.FirstName}

All of these group service orders by the tech's first name but unassigned service orders are MIA.

However, 

If {tblServiceOrders.TechAssigned} = 0 then "Unassigned"

results in correctly marking unassigned service orders and leaving the rest of the service orders without anything in the field.

What am I missing?

Thanks!!!