Crystal Reports null value field records not show

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: null value field records not show

Post Reply

Post New Topic

Author	Message
mjawadkhatri Newbie Joined: 09 Sep 2009 Location: Pakistan Online Status: Offline Posts: 14	Topic: null value field records not show Posted: 28 Sep 2009 at 10:15pm
	hi I am new in crystal report i need some help. i use six field in my report. contid,condate,supp,product,qty,invoice this is purches report, we doing 2 types of purches, one have no invoice number and 2nd have invoice number. i want to show that record have invoice number. hope u understand my question thanks in advance jawad khatri
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Sep 2009 at 7:04am
	Do you mean you want to write a select statement to only include records with an invoice number? If so you can use this in the select statement. *Not(isnull({table.invoicefield}))* Edited by DBlank - 29 Sep 2009 at 7:04am
	IP Logged

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