Sukumesh

Hi, My problem is Printing the Same Data Values in the Immediate Next Page. That is I am having one Pre Printed Paper source. I should print the details in the Respected Places. I should print the First Record in the Following Pattern Top Margin="10" Bottom Margin="50" Then The Same Record shld be in the Next Page also as Like Top Margin="50" Bottom Margin="10" this is the Pattern. If it is One record ok. If i have More than one Record Hw can i do that? Here i attached my Jrxml file Pls Help Me Thanks, Suresh [file name=AwbOriginalReport.jrxml size=30499]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/AwbOriginalReport.jrxml[/file]

Hi, Use if condition to Build the Query, I mean (($F{NAME})==null?"SELECT * FROM CITIES;":"SELECT * FROM CITIES WHERE NAME ='London'; Regards Suresh

Hi, I removed the Jexcel.jar and cleaned the src. Again Replaced the Jexcel.jar so now i am getting the Follwing error [junit] java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 [junit] at java.util.ArrayList.RangeCheck(ArrayList.java:507) [junit] at java.util.ArrayList.get(ArrayList.java:324) [junit] at jxl.write.biff.WritableWorkbookImpl.getSheet(WritableWorkbookImpl.java:382) [junit] at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:825) [junit] at net.sf.jasperreports.engine.export.JExcelApiExporter.closeWorkbook(JExcelApiEx porter.java:177) [junit] at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream( JRXlsAbstractExporter.java:305) [junit] at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbs tractExporter.java:135) And this is my Code JasperPrint jPrint = JasperFillManager.fillReport(dirName+"ExcelReport.jasper",parameters,jrDataSource); ByteArrayOutputStream outputByteArray = new ByteArrayOutputStream(); JExcelApiExporter exporterXLS = new JExcelApiExporter(); exporterXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jPrint); exporterXLS.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM,outputByteArray); exporterXLS.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporterXLS.setParameter(JExcelApiExporterParameter.IS_AUTO_DETECT_CELL_TYPE, Boolean.TRUE); exporterXLS.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE); exporterXLS.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); exporterXLS.exportReport(); byte[] byteArray = outputByteArray.toByteArray(); While Excuting this Code for PDF tht is working Fine For Excel now I am getting the Follwing Error. Pls Help Me Thanks, Suresh

Hi, I am having one Jexcel,jar and jxl.jar,xlrd.jar in my Classpath......... And Struts libs(i mean commons.......jars) is there any other jar containing commons method? Pls help me Thanks & Regards, Suresh

Hi, I integrated jasper1.2.5 and Tried for PDF report tht is working very fine. Then I tried to Create Excel export using JExcelApiExporter. But i am getting the Follwing error [junit] common.Assert.verify(Z)V [junit] java.lang.NoSuchMethodError: common.Assert.verify(Z)V [junit] at jxl.biff.XFRecord.<init>(XFRecord.java:447) [junit] at jxl.write.biff.CellXFRecord.<init>(CellXFRecord.java:50) [junit] at jxl.write.WritableCellFormat.<init>(WritableCellFormat.java:87) [junit] at jxl.write.WritableWorkbook.<clinit>(WritableWorkbook.java:56) [junit] at jxl.Workbook.createWorkbook(Workbook.java:393) [junit] at jxl.Workbook.createWorkbook(Workbook.java:376) [junit] at net.sf.jasperreports.engine.export.JExcelApiExporter.openWorkbook(JExcelApiExp orter.java:153) [junit] at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream( JRXlsAbstractExporter.java:229) [junit] at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbs tractExporter.java:135) Pls anybody cna help me to solve this error? Thangs & Regards, Suresh