Null Field
Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630
Printed Date: 20 Apr 2024 at 3:57am
Topic: Null Field
Posted By: lbuffett
Subject: Null Field
Date Posted: 16 Jun 2018 at 5:28pm
Hello
I am trying to figure out how to come up with code (within crystal 2016) that will only show students where the acceptance date is null. Hopefully, this will show me all students that are incomplete.
Anyone know or have an idea how to do it? I can find all kinds of SQL statements; however, I am not sure how to do it in crystal.
Les
|
Replies:
Posted By: kevlray
Date Posted: 18 Jun 2018 at 4:14am
In the select expert, go to the formula editor and do a isnull check on the acceptance date (i.e., isnull({somedate}). Also make sure the "Default Values for Nulls" is selected in the Formula Workshop.
|
Posted By: lbuffett
Date Posted: 19 Jun 2018 at 7:08am
Thank you, that is what I am looking for.
What if I wanted to report on 2 blank fields, would it be an if statement or would I just put it in the select expert such as:
ISNULL({Treatme2.AppUser}) and
ISNULL({Treatme2.AppDate})
Treatme2 is the table.
AppUser is the field.
|
Posted By: kevlray
Date Posted: 19 Jun 2018 at 9:08am
|
Looks correct to me. Don't forget about the "Default Values for Nulls"
|
|