Print Page | Close Window

Filter to show only Blank fileds.

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20001
Printed Date: 29 Nov 2022 at 8:31pm


Topic: Filter to show only Blank fileds.
Posted By: smccomish
Subject: Filter to show only Blank fileds.
Date Posted: 10 Sep 2013 at 12:10pm
I am new to crystal reports and am in need of help.

I have a field:{CmtMain.CmtIssueDate}

I want to show ONLY the entries that are blank for this date/time field (in my company it means the work is NOT completed).

this is the formula that I have
{CmtMain.CmtIssueDate} = DateTime (1999, 12, 22, 00, 00, 00)

how do I type the formula to show only the fields that are blank?



-------------
Thanks for your help!!



Replies:
Posted By: iSing
Date Posted: 10 Sep 2013 at 2:55pm
Hi smccomish
 
There's nothing really wrong with your formula, but it all depends on how your database handles the "empty" field. 
 
If the field doesn't exist - so if there is no entry in the field, then it doesn't exist, try:    isnull({CmtMain.CmtIssueDate})
 
If the field is empty (eg it exists, but there is no data in it), try:
totext({CmtMain.CmtIssueDate})=""
It's a different version of what you have, but it might work.
 
Check to see if your database's default date is actually 22nd December 1999 (as this is an unusual date to have as default).  If it is, try this in case your field is only a date field (and not a date/time field):
{CmtMain.CmtIssueDate}=Date(1999,12,22)
 
An all catch would be:
 
isnull({CmtMain.CmtIssueDate}) or
totext({CmtMain.CmtIssueDate})="" or
{CmtMain.CmtIssueDate}=Date(1999,12,22)
 


Posted By: smccomish
Date Posted: 11 Sep 2013 at 5:52am
Thank you very much! Worked perfectly. I have had NO training on CR. Just trying to teach myself. Thanks again!!

-------------
Thanks for your help!!


Posted By: iSing
Date Posted: 11 Sep 2013 at 2:44pm
Hi smccomish
 
No worries.
I have had training on CR & although it helped to work out where the bits were, I found that applying it to your own data & agency needs was the steep learning curve.
 
You'll find you'll be at this forum a lot.
Best of luck.



Print Page | Close Window