I am trying to do cascading multi select input control. I have two input control and the second input control list are depending on first input control. I am using Hibernate connection to the database. I am using $X in the clause is because, the first input control list might be null. Problem is i'm getting an error when running the report on jasper server as below. ....FROM User b WHERE $X{IN,b.country,COUNTRYLIST} No clause function for id IN found net.sf.jasperreports.engine.JRRuntimeException: No clause function for id IN found at If I change the clause to use $P, I have no problem to run the report ....FROM User b WHERE b.country in ($P{COUNTRYLIST}) I found there is a simiar case, but no one reply. http://community.jaspersoft.com/questions/705314/x-ebjql-query Hope you guys can help..Thanks in advance.
