Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

is null

Status
Not open for further replies.

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
 
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
 
Thanks

I wasn't sure if there was a selection criteria i could use rather than creating a formula...


Thanks Again

Paul
 
the isnull({table.field}) argument can be used as a selection criteria.

J
 
Thanks for your help on that. I need to think a little more logically a little hard on a Friday
Cheers

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top