hi , i am working on reports 6i ,
i have a field "ADVANCE" holds ( 1 or 2 ) , if 1 i want to show the check mark instead of number 1 , if 2 , i want to display nothing (null) .
i've tried the follwing in the format trigger of :advance field after changing it's font to wingdings western .
if :advance = 1
then
srw.set_field(0,10003) -- 10003 is the corresponding number of check mark in wingdings font .
else
srw.set_field(0,'') ;
end if;
return true ;
but it showed other figures , i think it does not parse the number 10003 .
any suggestions ?