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!

Select Expert NULL date 2

Status
Not open for further replies.

JohnOB

Technical User
Oct 5, 2006
253
GB
I have a date field and I want to use Select Expert to pull in records where the date field is NULL, however when I use select expert I seem only able to enter ranges in dates or higher or lower or equal to a certain date, however I wish to select where the field is NULL, I assume I could do this with the formula button though none of the strings I have tried have worked.

I am using CR10

Thanks

"Stupid isn't not knowing the answer, it's not asking the question
 
Please try this out.
when you got to select expert select formula for the datefield and
enter the formula editor
type :
isnull(datefield)
 
Tip: Do Not use the select expert. Just manually enter your record or group selection formula. You have much greater ability to control what you are doing without the select expert.

I have not used the select expert in 10 years.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Thanks, when I type this I get the message that the ) is missing. There is another where clause allready in the formula box, and the field name is in curly brackets, does this matter, do I need to somehow enclose them both in brackets. Here is how it currently looks, including your formula

Code:
{TABLE1.FIELD1} and
isnull (TABLE2.FIELD2)

Table1.field1 is a True/False field and I want the records selected where this field is also true.

Thanks for your help

"Stupid isn't not knowing the answer, it's not asking the question
 
Where would I manually enter the formula?

Thanks

"Stupid isn't not knowing the answer, it's not asking the question
 
what Dglizz meant was to create a formula in select expert using the show formula button,rather than using the drop down. you are doing the same thing now.
as for your question you need to enlcose the field in simple bracket. an example would be:
{BPCUSTOMER.SATTAX_0} in {?regiondeb} to {?regionfin} and
isnull({SORDER.ORDDAT_0})
check wether you have closed all the brackets that you have opened.
 
No that is not what I meant. I mean i NEVER use the select expert.

Go to report, edit selection formula, record.

Also for the record - I am not sure why - but the isnull() test must come first:

Isnull({YourField}) and ..........

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Clicking Report - Edit Selection Formula - Record is the same as clicking Select Expert - Show Formula - Formula Editor you can do either.

your formula for the date null should be

isnull ({nameofdatefield})

followed by 'and' then

any other formulas you have.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
Hi dgillz,
I think we both are saying the same point but the only difference is that we reach the formula editor through different ways.
If you create a record selection formula it will appear in the formula of the select expert
go to select expert->show formula->formula editor
you can see the same formula
the converse will also work
create a formula using select expert and go to
report->selectin formula-> record
you will find the same formula that you created using select expert here.
Please correct me if i am conceptually wrong.

Thanks,
Madhu
 
Thanks guys this worked!

"Stupid isn't not knowing the answer, it's not asking the question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top