Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: Null Field Post Reply Post New Topic
Author Message
lbuffett
Newbie
Newbie


Joined: 20 Jan 2017
Online Status: Offline
Posts: 6
Quote lbuffett Replybullet Topic: Null Field
    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   
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1436
Quote kevlray Replybullet 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.
IP IP Logged
lbuffett
Newbie
Newbie


Joined: 20 Jan 2017
Online Status: Offline
Posts: 6
Quote lbuffett Replybullet 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.

Edited by lbuffett - 19 Jun 2018 at 7:09am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1436
Quote kevlray Replybullet Posted: 19 Jun 2018 at 9:08am
Looks correct to me.  Don't forget about the "Default Values for Nulls"
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.