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.

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.

Hi, I am new to ireport and jasperreports. I have a designreport in which we have a report filling the single record and the other report which displays mutliple values of the same record(different attributes). These two reports should be in one report design.Both of these two reports use their own individual queries to get the values.In the first report id,name, age, dateof birth etc details are shown and in the other table contains id, logintime, logouttime(this table multiple records). how should I do this. please suggest some idea. thanks