Hello, I am trying to pass a parameter inside a case when statement within Jaspersoft, and was wondering whether this is possible? Thank you in advance! SELECT SUM(CASE WHEN S.CATEGORY IN $X!{IN,S.CATEGORY,SALESCAT} THEN 1 ELSE 0 END), COUNT(*) FROM SALES S