dheerajsea123 Posted December 2, 2008 Share Posted December 2, 2008 hi EveryOne,I have a one query i.e., i want to pass parameter in IN clause of sql statement in jasper report so pls help me out. how to do this.Any one replied me, it's urgent for me.waiting for ur reply.thanks Link to comment Share on other sites More sharing options...
dprogrammer Posted December 2, 2008 Share Posted December 2, 2008 hope this helps: SELECT * FROM Address WHERE City IN ( $P!{paramAddress} ) Link to comment Share on other sites More sharing options...
mdahlman Posted December 2, 2008 Share Posted December 2, 2008 A better solution is to use the syntax: $X{myParameter} It's discussed in more detail in other threads. Regards,Matt Link to comment Share on other sites More sharing options...
dheerajsea123 Posted December 3, 2008 Author Share Posted December 3, 2008 hi,ya thanks to give the solution of that, i have solved my problem by ur code.thanks.bye. Link to comment Share on other sites More sharing options...
dheerajsea123 Posted December 3, 2008 Author Share Posted December 3, 2008 hi,ya thanks to give the solution of that, i have solved my problem by ur code.thanks.bye. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now