Wednesday, June 27, 2018

To show  and tik mark and croos mark in oracle report;

1. first try to keep value for tik mark P and for cross mark O 
for help try as following query :

SELECT C.COMP_NO, C.COMP_DT, C.COMP_PRIORITY,
   C.COMP_PRIORITY_NM, C.COMPLAIN_FOR, C.COMP_FOR_NM,
   C.FOR_REF_NO, C.COMP_4REF_NM, C.COMP_DSCP,
   C.PRIMARY_ACT, C.COMP_TO_DEPT_NO,
   (SELECT DEPT_NAME FROM HR_DEPT WHERE DEPT_NO = C.COMP_TO_DEPT_NO) COMP_TO_DEPT_NAME,
   C.COMP_TO_EMP_NO,
   C.LOC_ROOM_NO, C.LOC_DEPT_NO, C.LOC_DESC,
   C.COMP_BY, C.COMP_BYDEPT_NM, C.COMP_DTTM,
   C.IDENTIFIED_BY, C.IDENTIFIED_DTTM, C.IDENTIFIED_BYDEPT_NO,
   DECODE(C.VERIFY_FLAG,  'Y', 'P', 'O') VERIFY_FLAG,
   C.VERIFY_DTTM, C.VERIFIED_BY,
   DECODE(C.VALID_FLAG,  'Y', 'P', 'O') VALID_FLAG,
   DECODE(C.SOLVE_FG,  'Y', 'P', 'O') SOLVE_FG, 
   DECODE(C.DECI_FG,  'Y', 'P', 'O') DECI_FG,
   C.ACTION_FG, C.VERIFY_COMMENT, C.COMPANY_NO
FROM CMV_COMPLAIN C

---
then just take filed font ~ windings(western)2 and enjoy it.

Screen short :

0 comments:

Post a Comment