irs_bandari Posted November 7, 2006 Share Posted November 7, 2006 hiI am passing an integer paramter to the jasper report.When I write the query to retrieve the fields in the query report, the type of the column which I want to send as a parameter is shown as java.math.BigDecimal. So Iam creating the parameter and the filed text as type bigdecimal.But when I am passing the query as select * from emp where id=$P!{id} where id is the parameter i have created its generating a blank pdf. when i change the query parameter select * from emp where id='$P!{id}', its generating the error as invalid number. Is it the problem with passing integer parameter. Please respond to me..thanks in advance. 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