Sep 6, 2005 #1 kemmm Technical User Jul 18, 2005 1 US I simply want to create a list of employees for my company that shows who has not enrolled in health insurance. How do I set my selection criteria for an empty field?
I simply want to create a list of employees for my company that shows who has not enrolled in health insurance. How do I set my selection criteria for an empty field?
Sep 6, 2005 1 #2 synapsevampire Programmer Mar 23, 2002 20,180 US Please remember to include basic technical information, such as the version of your software and the type of field. There are 2 possibilities, a null field or a blank field. I'll give an example for a field that would contain a Y or N in an alpha field Go to Reports->Edit Selection Formula->Record and place: ( isnull({table.field}) or {table.field} = "" or {table.field} = "N" ) This would check for it being either a null, or blank, or contain the letter N, adjust as required. Note that your lack of information degrading the quality of the response, as with most 1 or 2 line posts. Successful posts tend to include: Crystal version Database/connectivity used Example data Expected output -k Upvote 0 Downvote
Please remember to include basic technical information, such as the version of your software and the type of field. There are 2 possibilities, a null field or a blank field. I'll give an example for a field that would contain a Y or N in an alpha field Go to Reports->Edit Selection Formula->Record and place: ( isnull({table.field}) or {table.field} = "" or {table.field} = "N" ) This would check for it being either a null, or blank, or contain the letter N, adjust as required. Note that your lack of information degrading the quality of the response, as with most 1 or 2 line posts. Successful posts tend to include: Crystal version Database/connectivity used Example data Expected output -k