Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check mark

Eslam_ElbyalyApr 23 2016 — edited Jun 4 2016

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 ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2016
Added on Apr 23 2016
12 comments
3,145 views