INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Null formula discrepancy

Null formula discrepancy

(OP)
I'm using Crystal Report 11. I've run into a bump in the road with the record selection formula shown below. The report displays cases that are "pending", which means that the cases have not been classified with a classification code or classification date. Once in awhile a case that has been given a "classification" and "classification date will show on my "pending" report. I discovered that sometimes users will enter the "classification" code and "classification date" and hit the return key a couple of times, creating a blank space in those fields. The record selection formula will pickup the blank space and place the record in my "pending" report. What can I add to this formula to prevent it from happening? Thank you

(isNull({EXP_CLASSIFICATION.CLASSIFICATION}))
OR

(Trim({EXP_CLASSIFICATION.CLASSIFICATION})= "")
AND
Trim({EXP_CLASSIFICATION.CHANGE})=""

AND


IsNull({EXP_CLASSIFICATION.DATE})
OR {EXP_CLASSIFICATION.DATE} = date(0,0,0)

RE: Null formula discrepancy

The following should select records with a blank or null classification AND a blank or a null date. Based on your question alone, I'm not sure where Trim({EXP_CLASSIFICATION.CHANGE})="" fits in

CODE -->

(
isNull({EXP_CLASSIFICATION.CLASSIFICATION}
 OR
Trim({EXP_CLASSIFICATION.CLASSIFICATION})= ""
) 
AND 
(
IsNull({EXP_CLASSIFICATION.DATE}
OR 
{EXP_CLASSIFICATION.DATE} = date(0,0,0)
) 

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

RE: Null formula discrepancy

(OP)
Thanks CoSpringsGuy. The formula is doing what it supposed to do, it's identifying the blank or null field. But once in awhile a user will inadvertently enter data in the fields and then hit the return a couple times creating a new blank row. The formula bypasses the row with data and acts on the null/blank row, displaying the record as incomplete when in reality it has been completed and shouldn't show up on the report. I guess he formula should include a statement where data is present it should stop there and not evaluate the rest (null row). I'm at a loss on how I should proceed.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close