psoma.cse

Hi Lucian, Thanks for your reply. As a temporary fix, I changed the font,size and the stretch type to 'Tallest Object'. And the report came up fine in Linux also after the above change. Let me try by setting the 'Issplitallowed' property also as I wish to know the reason for this behaviour. Thanks Again... :) Somu

Hi All, We have an excel report generated by Jasperreports(ver3.0), the format of which is uneven only in Linux.The problem is that after every 30 row, an additional line is generated and part of the data from previous row is displayed on the 31st row. This happens after every 30 rows.The same report looks good in Windows. I have set the following parameters in the code: xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE) xlsExporter.setParameter(JRXlsExporterParameter.IS_IGNORE_GRAPHICS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE); Please let me know the reason for this format issue and the solution for the same. Environment: iReport3.0 & JasperReport3.0 Note: I have attached sample xls report.After every row, u can see a additional row with data overlapped from previous line. Thanks, Somu [file name=sample-260b18a08e4f1445df009b6b4da3ac65.xls size=22528]

Hi All, We have an excel report generated by Jasperreports(ver3.0), the format of which is uneven only in Linux.The problem is that after every 30 row, an additional line is generated and part of the data from previous row is displayed on the 31st row. This happens after every 30 rows.The same report looks good in Windows. I have set the following parameters in the code: xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE) xlsExporter.setParameter(JRXlsExporterParameter.IS_IGNORE_GRAPHICS, Boolean.TRUE); xlsExporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE); Please let me know the reason for this format issue and the solution for the same. Environment: iReport3.0 & JasperReport3.0 Note: I have attached sample xls report.After every row, u can see a additional row with data overlapped from previous line. Thanks, Somu [file name=sample.xls size=22528]

Hi, Thanks for your information. I had the same problem and now got them fixed with your help. Thanks, Somu

Hi Everyone, I have a report that needs to be exported to xls format in a single page. Through iReport, I'm able to generate a single page continuous xls report(with no empty lines in-between). I have two problems with this report. Pbm 1: First problem is that the same report comes bad when generated through the application. Many empty lines appear randomly after some set of rows throughout the report. Infact the number of empty lines increases as we go down the report. Please give me some suggestions for this issue. Pbm 2: We want to be able to have exactly the same number of rows as in the table in the generated report. Currently some extra 30 lines appear in the report due to the over flow of text. Please note that for some column of a row, the data is over 100 lines(when put in a doc file). Note: I have set the foll. parameters in the code: 1. JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE 2. JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE Also, I have enabled the 'stretch with over-flow' property of the Text fields in iReport. I have attached the genereted excel report for your reference. I feel that both the problems have the same cause ie text over flow. If there is way so that the text of a column, does not over flow to the next row, this issue can be resolved. I looked in to the previous forum questions, but still trying to fiqure out the solution. Thank you very much for your time! -Somu

Hi Everyone, I have a report that needs to be exported to xls format in a single page. Through iReport, I'm able to generate a continuous xls report(with no empty lines between). But the problem is that the same report comes bad when generated through the application. Many empty lines appear randomly after some set of rows throughout the report. Infact the number of empty lines increases as we go down the report. Please give me some suggestions for this issue. Note: I have set the foll. parameters in the code: 1. JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE 2. JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE Thank you very much for your time! -Somu