I am using $X variable but it gives me the error non supporet sql exception :IN i have to pass multiple parameter here i have tried many combinations of $X{IN,p.sac_no,SAC_NO} but cant get any idea.i ma using ireport 1.2.7.plz... hepl me if anyone knows . Code: Post Edited by asim1985 at 09/12/2011 06:35 Post Edited by asim1985 at 09/12/2011 06:36