Hi all - I am running CR XI.

I am trying to replace nothingness with something. In our TrackIt database, some users do not select anything from the pulldown menues, and that is not totally clear when creating a report (especially if I am creating groups based on what was selected). I would like to replace a null field with the word "omitted" to make this clearer, as our managers wish to alert the technicians who are leaving certain fields blank.

So far I have tried this:

if {TASKS.WOTYPE3} = "" then "omitted"

but that isn't working. I am not sure how to express a null field (or perhaps this field is not null and contains whitespace? I'm not sure). Any tips would be quite helpful.

Thanks!

Excellent! Thanks.

I was going to say that I also tried:

if !{TASKS.WOTYPE3} then "omitted"

(note the "not" qualifier '!"), but that is syntactically wrong.

You responded before I could post that though. Thanks for the tip!

In this case, I do not really want to replace a missing DUEDATE with the word "omitted". I actually do not want to even read in any record where the DUEDATE field is missing. I couldn't figure out how to do that, which is why I figured I'd just swap it with a keyword (like omitted) and then work from there.

If you know of a way for me to just skip over records with no DUEDATE, that would even be more helpful. I tried doing it with "Select Expert", choosing
"is not in the period" but the choices provided are not really right for what I'm trying to do. Thanks.

Thanks DBlank.

isnull ({TASKS.DUEDATE}) = FALSE

is exactly what I wanted.

I may have to do some delta math on dates now, but will start a new thread for that (but I'll read back through past posts first before doing so).

Thanks a lot!