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.


Null formula discrepancy

Null formula discrepancy

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





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 -->


Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

RE: Null formula discrepancy

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!


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