Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    20

    Unanswered: Won't let me choose NULL

    I'm in the select expert and i want to pull all the info that does not have a date in my column. The SQL database has NULL in this field. i am selecting IS EQUAL TO in the dropdown then typing NULL , it gives me an error - a number, date date time, boolean, or string is expected here. anyway i can pull the fields that don't have a date in the field i even tried formula:

  2. #2
    Join Date
    Aug 2004
    Posts
    15
    In Crystal 7 I use isnull({table.field} = true

  3. #3
    Join Date
    May 2006
    Posts
    20
    I'm on 11 it says this field name is not known

  4. #4
    Join Date
    Aug 2004
    Posts
    15
    I left if you followed my syntax exactly I left out a parenthesis. It should have been isnull({table.field}) = true

  5. #5
    Join Date
    May 2006
    Posts
    20
    It did work i didn't have AND after my last filter. that was causing the error thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •