liya1234

Hi Please help me when using excel formula ,it works like a real excel .but i am not getting decimal up to 4 places i am using net.sf.jasperreports.export.xls.formula and expression like $F{rate}==0 ? "_" : (new java.text.DecimalFormat("###0.0000;(###0.0000)")).format($F{rate}) but results is like 1.23 .i want 1.2345 Anybody know this please help me urgent liyak9@gmail.com

please send me the jrxml file @ liyak9@gmail.com

i didnt get value in upto 4 decimal place when using excel formula.I am getting only decimal place upto 2 wat to do please help me

Hi, DISPLAYED DATA IN DETAIL BAND TAKING FROM RESULTSET.FOR ONE CONDITION I WANT TO DISPLAY 6 RECORDS.I HAVE TO PASS MORE THAN ONE IDS .SO THE RESULT WILL BE MORE THAN 6 RECORDS.I HAVE TO SEPERATE THIS RECORDS AS TWO OR THREE SET I have attached the report format . I displayed the second section ie(verification result) part as subreport.In subreport query i have retrived result as 6 records for 1 condition.i have to use more than one condition that means my query is like select * from ..... where id in(' ab',' cd' ).Then i retrive data as like in the resultset. But i want to display like two or 3 block depends on condition.How can i seperate this resultset data in detail band .I HAVE ATTACHED THE REPORT FORMAT AND JRXML FILES