is null

[Willie78]

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

 

[TheBlondOne]

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

 

[Willie78]

Thanks

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


Thanks Again

Paul

 

[TheBlondOne]

You can put that in the select expert.

 

[CR85user]

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

J

 

[Willie78]

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

Paul