Crystal Reports Selection of Field (null)

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

Topic: Selection of Field (null)

Author	Message
EvdK Newbie Joined: 04 Sep 2007 Location: Netherlands Online Status: Offline Posts: 4	Topic: Selection of Field (null) Posted: 04 Sep 2007 at 2:37am
	Hi, My question - I want to make a report and want to select all fields with date null (fields not filled in/are empty). I tried {T_DossierMain.QuotDate} = Date (0, 0, 0) but get no records. Is it possible to select an not filled/empty field and if so how to do! Thanks for replay
	IP Logged

foxy Groupie Joined: 12 Jul 2007 Online Status: Offline Posts: 50	Posted: 04 Sep 2007 at 3:18am
	try this formula isnull({T_dossierMain.QuoteDate}) Hope this works
	FOXY
	IP Logged

EvdK Newbie Joined: 04 Sep 2007 Location: Netherlands Online Status: Offline Posts: 4	Posted: 04 Sep 2007 at 4:36am
	Thanks for your reaction Get an error “this field name is not know” Someone another suggestion Thanks
	IP Logged

foxy Groupie Joined: 12 Jul 2007 Online Status: Offline Posts: 50	Posted: 04 Sep 2007 at 5:05am
	Sorry I got your field name wrong! i put an extra 'e' in the middle of it. it should be isnull({T_DossierMain.QuotDate}) apologies
	FOXY
	IP Logged

EvdK Newbie Joined: 04 Sep 2007 Location: Netherlands Online Status: Offline Posts: 4	Posted: 04 Sep 2007 at 5:38am
	Again thanks for your reaction. I had played again and came to this formula: {T_DossierMain.QuotDate} = CDateTime (0, 0, 0) It works!!!!!! Till........
	IP Logged

foxy Groupie Joined: 12 Jul 2007 Online Status: Offline Posts: 50	Posted: 04 Sep 2007 at 5:43am
	I would have thought that will be bringing back the wrong data. That formula just converts the 0,0,0 to a date and then assigns it to the field. If you want to check to see which fields are null already and then return them then you need to put the formula i gave you in the record selection formula.
	FOXY
	IP Logged

EvdK Newbie Joined: 04 Sep 2007 Location: Netherlands Online Status: Offline Posts: 4	Posted: 07 Sep 2007 at 4:50am
	I tried your way but no success. Again looking to the standard options – I tried {T_DossierMain.QuotDate} > Date (0, 0, 0) And also this works. Thanks again for your reaction. Till
	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.