problem with if then else statement

[Former Member]

hello experts,

i am appreciating some help in if then else statement in crystal report.

numbervar x:={ev1.Hpronunciation};

if({ev1.class}="LKG" OR {ev1.class}="UKG") then

(

if(x>=9 and x<=10 )

then

"A+"

else if(x>=6 and x<=8 )

then

"A"

else if(x>=4 and x<=5 )

then

"B+"

else if(x>=3 and x<4 )

then

"B"

else if( x<3 )

then

"C"

else if( x=999 )

then

"AB"

else if( x=0 )

then

"*"

else

"")

else

(

if(x=5 )

then

"A+"

else if(x=4 )

then

"A"

else if(x=3 )

then

"B+"

else if(x=2 )

then

"B"

else if( x<2 )

then

"C"

else if( x=999 )

then

"AB"

else if( x=0 )

then

"*") ;

i am getting correct result for first condition ,but  blank result for else ,can any one help me figure out where i am wrong

[DellSC · Accepted solution]

Is it possible that any of the fields have null values?  If so, see my blog post about null handling in Crystal for more information:  What is Null and Why is it Important for Crystal Reports | SAP BI BLOG

-Dell

[Former Member · Accepted solution]

thanks dell,your suggestion works.