Condition..! [modified]
-
--> 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
-
--> 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
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
-
42
Never underestimate the power of human stupidity RAH
-
--> 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
Try using:
if vSTUDENT_FEE_DETAIL.Admission Is Nothing thenhthLike car accidents, most hardware problems are due to driver error. Samir R. Ibrahim
-
Try using:
if vSTUDENT_FEE_DETAIL.Admission Is Nothing thenhthLike car accidents, most hardware problems are due to driver error. Samir R. Ibrahim
--> this the code in the crystal report's formula. it does not support nothing in there. :)
J A Nasir K
-
--> wat do u mean by "3".?
J A Nasir K
-
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
--> actually Admission got values and null values as well. stil have a problem...
J A Nasir K
-
--> this the code in the crystal report's formula. it does not support nothing in there. :)
J A Nasir K
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
-
--> wat do u mean by "3".?
J A Nasir K
-
--> this the code in the crystal report's formula. it does not support nothing in there. :)
J A Nasir K
Don't tell any one :)
Like car accidents, most hardware problems are due to driver error. Samir R. Ibrahim