passing integer as parameter

[irs_bandari]

hi

I 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.