Solved

Crystal Reports formula - only want to show null values for a field

Posted on 2013-12-04
4
2,913 Views
Last Modified: 2013-12-05
I have a report that I only need to look at the items if there is a null value in the date field.  I cannot seem to get the formula correct to only show the null values.

Any ideas?  The field is LabelDate
0
Comment
Question by:delta1734
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 39697335
just do a conditional supress formula for that field

  NOT isnull ({lbldate})

then it should only display those that are null
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39697444
Use the record selection

IsNull({LabelDate})

You can also use suppression as mentioned above but put it on the section so you don't see any of the data for that record.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39697446
Are you usiing multiple tables?
If so is the date field on the joined table?

mlmcc
0
 

Author Closing Comment

by:delta1734
ID: 39698142
This worked great. Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question