Condition..! [modified]

[Jamal Abdul Nasir]

--> i am using the following code in crystal reports XI's formula...

if isnull({vSTUDENT_FEE_DETAIL.Admission}) then
formula = "ooooo"
else
formula = "yyyyy"
end if

--> i am not getting the expecting result. --> if the ADMISSION is NULL then it should print "ooooo" else "yyyyy". --> when it is not NULL it displays the right result that is "yyyyy", but when it is NULL then it displays nothing.. --> ADMISSION is the field in the database table. --> give me any clue. --> thanks....

J A Nasir K

modified on Thursday, May 21, 2009 4:30 PM

[Lost User]

Jamal Abdul Nasir wrote:

--> give me any clue.

Check out the CodeProject forum Guidelines[^]

[0x3c0]

Perhaps ADMISSION isn't null (with no value at all), but just an empty string. Alternatively, since that in itself wouldn't produce the result you received, you may be terminating program flow if ADMISSION is null before you ever actually get to the condition

[Mycroft Holmes]

42

Never underestimate the power of human stupidity RAH

[Samir Ibrahim 0]

Try using: if vSTUDENT_FEE_DETAIL.Admission Is Nothing then hth

Like car accidents, most hardware problems are due to driver error. Samir R. Ibrahim

[Jamal Abdul Nasir]

--> this the code in the crystal report's formula. it does not support nothing in there. :)

J A Nasir K

[Jamal Abdul Nasir]

--> wat do u mean by "3".?

J A Nasir K

[Jamal Abdul Nasir]

--> actually Admission got values and null values as well. stil have a problem...

J A Nasir K

[Mycroft Holmes]

Jamal Abdul Nasir wrote:

this the code in the crystal report's formula

Would have been useful in the OP. if you own the select change the select/proc to return a non null value

Never underestimate the power of human stupidity RAH

[Lost User]

I mean "--> GET A CLUE"

Check out the CodeProject forum Guidelines[^]

[Samir Ibrahim 0]

Don't tell any one :)

Like car accidents, most hardware problems are due to driver error. Samir R. Ibrahim