I've been suck on this issue for some time now. I have been trying to set a dynamic default date in a parameter to 12 month (or a year) prior to the current date. I've tried many many things, but nothing is working as I need it to. I've contacted JasperSoft Support and they've been unhelpful up to this point. If you know how to do this, then you can stop reading right here and post the solution and I will be very grateful. Now this part ismore of a SQL question than iReport. Since this question has been holding me up for way too long, I decided just to make a default date in my query knowing that if there is no default value expression in the parameter it will just return NULL. Yet for some reason, despite the fact that I know these functions work, they both return null values in this query. Can anyone tell me what I'm doing wrong? (I'm using a Netezza server by the way) SELECT current_date AS DATE_NOW, add_months(current_date,-12) AS DATE_START, sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE") AS ACCEPTEDD, case when (sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE")) = 0 then 0 else (sum(S_PH_AGG_EMAIL_PROMO."IS_OPENED"))/(sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE")) end AS PERC_OPENED, case when (sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")) = 0 then 0 else (sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE")) / sum(S_PH_AGG_EMAIL_PROMO."IS_SENT") end AS PERC_ACCEPTED, case when (sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE")) = 0 then 0 else (sum(S_PH_AGG_EMAIL_PROMO."IS_CLICKED"))/(sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE")) end AS PERC_CLICKED, case when (sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE")) = 0 then 0 else (sum(S_PH_AGG_EMAIL_PROMO."IS_UNSUB"))/(sum(S_PH_AGG_EMAIL_PROMO."IS_SENT")-sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE")-sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE")) end AS PERC_UNSUB, sum(S_PH_AGG_EMAIL_PROMO."IS_SENT") AS SENT, sum(S_PH_AGG_EMAIL_PROMO."IS_SBOUNCE") AS SBOUNCE, sum(S_PH_AGG_EMAIL_PROMO."IS_HBOUNCE") AS HBOUNCE, sum(S_PH_AGG_EMAIL_PROMO."IS_OPENED") AS OPENED, sum(S_PH_AGG_EMAIL_PROMO."IS_CLICKED") AS CLICKED, sum(S_PH_AGG_EMAIL_PROMO."IS_UNSUB") AS UNSUB, S_PH_AGG_EMAIL_PROMO."SEND_DT" AS SEND_DT, S_PH_DIM_CAMP."INITIATIVE" AS INITIATIVE, S_PH_DIM_CAMP."CAMP_NAME" AS CAMP_NAME FROM "ADMIN"."S_PH_DIM_CAMP" S_PH_DIM_CAMP INNER JOIN "ADMIN"."S_PH_AGG_EMAIL_PROMO" S_PH_AGG_EMAIL_PROMO ON S_PH_DIM_CAMP."CAMP_ID" = S_PH_AGG_EMAIL_PROMO."CAMP_ID" WHERE SEND_DT >= CASE WHEN $P{dateStart} is NULL THEN DATE_START ELSE $P{dateStart} END AND $X{IN, S_PH_DIM_CAMP."INITIATIVE", campType} AND SEND_DT <= $P{dateEnd} AND SEND_DT IS NOT NULL GROUP BY INITIATIVE, CAMP_NAME, SEND_DT ORDER BY SEND_DT ASC
