Crystal Reports Null Field

Writing Code
Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code

Topic: Null Field

Author	Message
lbuffett Newbie Joined: 20 Jan 2017 Online Status: Offline Posts: 7	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 Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	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 Logged

lbuffett Newbie Joined: 20 Jan 2017 Online Status: Offline Posts: 7	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 Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 19 Jun 2018 at 9:08am
	Looks correct to me. Don't forget about the "Default Values for Nulls"
	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.016 seconds.