I has a SQL query that has 4 Jasper praemeters. Everything was working fine until i chnaged one of the paramters $P to $X(IN). I need the user to be able to select from a list of values rather than just entering a single value. The problem seems to be arount the 'WHERE $X{IN' statement. Anyone have any ideas? select UPPER(st.aud$user) Technician, substr(n.name_last,1,15)||' '||substr(n.name_first,1,15) DonorName, st.donor_id donorId, dn.donor_number Donor, v.visit_date VisitDate, v.visit_number VisitNumber , st.scrntype_id, (select stt.code from stdnr.screening_test_types stt where st.scrntype_id = stt.id) ScreeningCode, d.birth_date DonorBirthDatefrom stdnr.aud$screening_tests ST, stdnr.visits V, stdnr.donors D, stdnr.donor_numbers DN, stdnr.names NWHERE $X{IN, ST.AUD$USER, TECHNICIAN} and st.visit_id = v.id and v.donor_id=d.id and d.id = dn.donor_id and d.id = n.donor_id and v.visit_date between $P{VISITFROM} and $P{VISITTO} and (select stt.code from stdnr.screening_test_types stt where st.scrntype_id = stt.id) = UPPER($P{SCREEN}) order by technician,donorname , visitdate