Hi All, The issue got resolved by using the latest version of jasperreport jar file.(jasperreports-2.0.4.jar). We were using a little older one(jasperreports-2.0.0.jar).
Thanks, Somu SomunNabble wrote: > > 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 > http://www.nabble.com/file/p15009963/report.xls report.xls > -- View this message in context: http://www.nabble.com/Problem-with-single-page-excel-Report-tp15009963p15032615.html Sent from the jasperreports-questions mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions