Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Null Date Post Reply Post New Topic
Author Message
swiz
Newbie
Newbie
Avatar

Joined: 20 Mar 2012
Online Status: Offline
Posts: 2
Quote swiz Replybullet Topic: Null Date
    Posted: 20 Mar 2012 at 7:10pm
I am a new Crystal user and am trying to select only records that have a null date field i.e. only those records that have "closed date" = null.
I have tried the following but it removes all records. In my data I have 10 records with no closed date and a couple with a closed date.
 
and isnull({wkrofile.closed_date})
 
Please help.
 
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 21 Mar 2012 at 10:33am
fyi:  always to null checks first (why, I don't know, it has been an issue with CR for years).   I hope this helps.
IP IP Logged
swiz
Newbie
Newbie
Avatar

Joined: 20 Mar 2012
Online Status: Offline
Posts: 2
Quote swiz Replybullet Posted: 21 Mar 2012 at 11:35am
Sorry if I am showing my ignorance but I am not sure what you mean - what string do I have to enter to get only records with No Closed Date?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 22 Mar 2012 at 6:00am
I am just saying if you have a isnull filter then it should be first before any other filter.   Also check in your options (worded a little different in some versions) for 'Convert Other NULL Values to default'.  There is also the same check in Report Options (which I believe overrides the Option settings).  Then there is the 'Exception for NULLS' in the formula editor.

Nulls always seems to an issue with me, so I almost always set an formula while developing a report that will show me the result of a null check (i.e.  In a formula just put isnull({wkrofile.closed_date} and see what you get).

I hope this helps.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.