How to make two groups when there are three values

[JonAtHQ]

Hello,

We have employee records with a checkmark as a field to indicate whether someone works from home or not. The records have been imported from another database, so the values for the checkmark are "1", "0" or "NULL".

How do I create a report that produces only two groups? I would like to show the people who work at home (1) together, and the people who do not work at home in another group (0 or NULL).

(Crystal XI)

Thanks.

 

[lbass]

if isnull({table.chkmark}) or
{table.chkmark} = 0 then "NotAtHome" else
if {table.chkmark} = 1 then
"AtHome"

If you mean there is a literal string result "NULL" and if the field is in fact a string, then change the formula to:

if {table.chkmark} in ["Null", "0"] then
"NotAtHome" else
if {table.chkmark} = "1" then
"AtHome"

-LB

 

[JonAtHQ]

Perfect. Your first answered worked. Thanks much!

I know this was a rather simple syntax question, but we're business users here using a COTS package, left to customize reports ourselves. So, we try this for a few hours ourselves, then give up, finally posting to Tek-Tips.