pcouas_1 Posted March 10, 2016 Share Posted March 10, 2016 Hi, JasperServer.log give me following error message "java.lang.IllegalArgumentException: Null 'key' argument."But my complet query is running into SQLDevelopper !The error is in subpart($P{isGrpMoreTweleve} ? "(CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) WHEN '1' THEN 'First Qtr' WHEN '2' THEN 'Second Qtr' WHEN '3' THEN 'Third Qtr' WHEN '4' THEN 'Fourth Qtr' end)" : "to_char(iv.inventory_date,'MON-YYYY')")($P{isGrpMoreTweleve} is an boolean with defaultValue Regardsjasperserver.logquery string: SELECT (to_char(iv.inventory_date,'YYYY') || (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ) AS tri, (CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) WHEN '1' THEN 'First Qtr' WHEN '2' THEN 'Second Qtr' WHEN '3' THEN'Third Qtr' WHEN '4' THEN 'Fourth Qtr' end) AS label, NVL(SUM(va.QUANTITY_USED),0) AS value1, va.VESSEL_UID, ve.VESSEL_NAME,(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) )||':'||(CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) WHEN'1' THEN 'First Qtr' WHEN '2' THEN 'Second Qtr' WHEN '3' THEN 'ThirdQtr' WHEN '4' THEN 'Fourth Qtr' end) as trititleFROM LO_VALUATION va,LO_VESSEL ve,lo_inventory ivWHERE va.VESSEL_UID=ve.VESSEL_UIDand va.month=iv.inventory_monthand ve.TEU_UID in (2,6,8,12)and iv.inventory_date BETWEEN to_date('20/09/2010','DD/MM//YYYY') AND to_date('01/10/2013','DD/MM//YYYY')GROUPBY (to_char(iv.inventory_date,'YYYY') ||(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ), (CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) WHEN '1'THEN 'First Qtr' WHEN '2' THEN 'Second Qtr' WHEN '3' THEN 'ThirdQtr' WHEN '4' THEN 'Fourth Qtr' end), va.VESSEL_UID,ve.VESSEL_NAME,(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) )||':'||(CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) WHEN'1' THEN 'First Qtr' WHEN '2' THEN 'Second Qtr' WHEN '3' THEN 'ThirdQtr' WHEN '4' THEN 'Fourth Qtr' end)ORDER BY(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ), (CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) WHEN '1'THEN 'First Qtr' WHEN '2' THEN 'Second Qtr' WHEN '3' THEN 'ThirdQtr' WHEN '4' THEN 'Fourth Qtr' end), va.VESSEL_UID ASC2016-03-10 19:20:31,351 ERROR AsyncJasperPrintAccessor,pool-4-thread-56:315 - Error during report executionjava.lang.IllegalArgumentException: Null 'key' argument.[/code] Link to comment Share on other sites More sharing options...
pcouas_1 Posted March 11, 2016 Author Share Posted March 11, 2016 That's Ok with DECODE function Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now