Jul 29, 2005 #1 Willie78 Technical User Jun 4, 2004 67 GB Hi all I have a Crystal Report with a number field. I want to be able to select null values in this field. 1 Is this possible???? 2 What would my selection criteria be I hope you can help cheers Paul
Hi all I have a Crystal Report with a number field. I want to be able to select null values in this field. 1 Is this possible???? 2 What would my selection criteria be I hope you can help cheers Paul
Jul 29, 2005 #2 TheBlondOne Programmer May 22, 2001 346 GB Yes this is possible, you can do the following isnull({number.field}) If you put this into your select expert then it will only return null values in your report. HTH Steve Upvote 0 Downvote
Yes this is possible, you can do the following isnull({number.field}) If you put this into your select expert then it will only return null values in your report. HTH Steve
Jul 29, 2005 Thread starter #3 Willie78 Technical User Jun 4, 2004 67 GB Thanks I wasn't sure if there was a selection criteria i could use rather than creating a formula... Thanks Again Paul Upvote 0 Downvote
Thanks I wasn't sure if there was a selection criteria i could use rather than creating a formula... Thanks Again Paul
Jul 29, 2005 #4 TheBlondOne Programmer May 22, 2001 346 GB You can put that in the select expert. Upvote 0 Downvote
Jul 29, 2005 #5 CR85user Technical User Jan 18, 2005 522 GB the isnull({table.field}) argument can be used as a selection criteria. J Upvote 0 Downvote
Jul 29, 2005 Thread starter #6 Willie78 Technical User Jun 4, 2004 67 GB Thanks for your help on that. I need to think a little more logically a little hard on a Friday Cheers Paul Upvote 0 Downvote
Thanks for your help on that. I need to think a little more logically a little hard on a Friday Cheers Paul