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 :
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