Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: change null date to blank Post Reply Post New Topic
Author Message
JMAO
Newbie
Newbie


Joined: 14 Jan 2014
Online Status: Offline
Posts: 9
Quote JMAO Replybullet Topic: change null date to blank
     Posted: 15 Jan 2014 at 6:54am

New at this. I have a date field that is showing all pound signs because it has a default null value if it is not populated.  How do I get the null date to show as blank when there is no value?  Example:  I am creating a benefit information file, and I need to send active staff and staff  who have terminated since the last file.  As you can imagine, only a few people have a termination date. Thanks

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Jan 2014 at 6:58am
you can conditionally syuppress the field
right click on it
select format field
select common tab
select the formula option (x-2) next to 'suppress;
enter your condition into the formula editor
table.datefield=your default value
e.g. {employee.termdate}=date(1900,1,1)
IP IP Logged
JMAO
Newbie
Newbie


Joined: 14 Jan 2014
Online Status: Offline
Posts: 9
Quote JMAO Replybullet Posted: 15 Jan 2014 at 7:06am

Success, many thanks! Smile

IP 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