prachu.kul

Thanks for reply buddy.... I've configured jasper server also where m deploying JRXML.but before deploying it,is there any way to add In parameter to query from input control? I've my main PLSQL query like...."blah blah....IN( 1 , 2 , 3 ,4 ) " here 1,2,3,4 are multiple parameters of integer type which i've to pass from input control(now i've done this hardcoded).If I take 1,2,3,4 as String then it's giving me exception of class cast.i.e String cannot be cast into Integer.I can't change IN parameter datatype on database side. If you are facing same problem,plz let me know how to solve this.Any hint,any suggestion will make huge difference. Thanks again.

I want to display data for multiple locations by passing location codes which are of Integer type to the query. For that I used $X{ IN, loc_cd, loc_codes } where loc_cd is column_name and loc_codes is parameter_name of java.util.Collection type. But the error comes as "net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: No clause function for id IN found". Please, help me out. Thanks in advance.