Strange Behaviour of Crystal Report
-
Hello, I have created one crystal report in VS 2005. Its datasource is ref cursur returned by oracle stored procedure and it is working fine except one formula filed which i have code like following: Here CURSPKG_JOIN is the name of oracle package and OPEN_JOIN_CURSOR1 is the name of stored procedure. Name of formula field is:finalres iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R1}='G' or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R2}='G' or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R3}='G' or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R4}='G' or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R5}='G' or {CURSPKG_JOIN.OPEN_JOIN_CURSOR1.R6}='G', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='1','FIRST DIVISION BY GRACE', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='2','SECOND DIVISION BY GRACE', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='3','THIRED DIVISION BY GRACE', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='C','SUPPLEMENTARY', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='F','FAILED', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='P','PASSED', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='Z','PARTIALLY PASSED', 'xx'))))))) , iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='1','FIRST DIVISION', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='2','SECOND DIVISION', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='3','THIRED DIVISION', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='C','SUPPLEMENTARY', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='F','FAILED', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='P','PASSED', iif({CURSPKG_JOIN.OPEN_JOIN_CURSOR1.FR}='Z','PARTIALLY PASSED', 'yy')))))))) and i put this formula filed on to the report; but it is printing the required result at somewhere and somwhere no print (even, i have given the false part i.e. 'xx' and 'yy') even with the same condition. I have double checked the data in the table and just for checking; i have placed the FR column on the report, which is carrying right value though. FR column is varchar2 length 1 character. Please guide me where i am missing....! Thanks & Regards Girish Sharma