Crystal Reports null record selection based on date Range

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: null record selection based on date Range

Post Reply

Post New Topic

Author	Message
lsalih Groupie Joined: 27 Sep 2007 Location: United States Online Status: Offline Posts: 44	Topic: null record selection based on date Range Posted: 14 Mar 2009 at 10:27pm
	Hi - I am tasked to create a report that shows all visitors that have been in a facility between specific dates range (June, 20-July 18). What I need is to display all records that have null values in a field called leftDT based on the specified time range. Could you please tell me how you do that in Crystal? Thanks.
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 15 Mar 2009 at 7:18am
	assuming you want this for june to july 2008 and it hard coded (not selected at run time) and your beging and end date range points to the same date field... in the Select Expert add: *{table.datefield} in cdate(#6/20/2008#) to cdate(#7/08/2008#) and IsNull({table.leftDT})* If they point to different date fields: *{table.datefield_Start}=>cdate(#6/20/2008#) and {table.datefield_End}=<(#7/08/2008#) and IsNull({table.leftDT})* If they need to enter ranges at run time you need to use parameters. Edited by DBlank - 15 Mar 2009 at 7:19am
	IP Logged

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