Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Date range but allow records without a date Post Reply Post New Topic
Author Message
Lynn06
Newbie
Newbie


Joined: 27 Jan 2015
Online Status: Offline
Posts: 4
Quote Lynn06 Replybullet Topic: Date range but allow records without a date
    Posted: 11 Feb 2016 at 7:13am
Hello,

I am writing a report that includes the following date range parameter. I have some records that do not have a value in Due To, so I would like to include any records that do not have a date in the results. I have tried the Isnull({DueTo}) formula with the one below and haven't had any luck!

{DueTo}>={?BegDate} and
{DueTo}<={?EndDate}
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Feb 2016 at 9:24am
(Isnull({DueTo}) or
{DueTo} in {?BegDate} to {?EndDate})
IP IP Logged
Lynn06
Newbie
Newbie


Joined: 27 Jan 2015
Online Status: Offline
Posts: 4
Quote Lynn06 Replybullet Posted: 16 Feb 2016 at 9:47am
Thank you for the information above. I tried that in my selection and it didn't pull in any records with blank dates. Do I need to make any changes to my parameter setting?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Feb 2016 at 2:43am
you are using a newer version of crystal that allows for null parameters?
Please explain what you want it to do when the param is empty and when it is not.

Edited by DBlank - 17 Feb 2016 at 2:43am
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.014 seconds.