overday

I have a report (html report) in Jasper, generated with a XML file. Here's the file: [file name=generator.xml size=19352]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/generator.xml%5B/file] There`s some info on the page footer band: system name, login info, time, and page number. The problem is: when I generate the html report, the page is ending before the actual page end. I mean, it's like this: ]http://img114.imageshack.us/img114/843/html1cm3.jpg It should be like this: ]http://img389.imageshack.us/img389/5908/html2xv4.jpg Don`t know why is Jasper switching pages earlier than he should do. He are receiving a lot of compaining from our clients, and I need to resolve this problem :( Thanks!

Problem solved (that was fast). I just set exporterXls.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.FALSE); to Boolean.TRUE :P

After days working on it, my Excel Report is almost perfect (i.e. almost like I need it to be :P). However, there is one final problem I need to solve. There is a zip file attached to this topic. There you'll find the xls file (my report), and the xml Jasper uses to generate the report. [file name=excel_report.zip size=14322]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/excel_report.zip[/file] Open the xls, please. The problem is: Jasper is generating some empty rows (row 19 and row 36 in the attached file). I know why it happens. If you click the "Print Preview" button, you'll see that thoses empty lines are there to fill the remaining space between the last result and the end of the printing area, in every page. I just don't know how to make Jasper to not generate those lines! In the example xls, the row 19 should not exist (20 should be 19, 21 should be 20, and so on), as 36 should not exist too (37 should be 36, ...). Is there a way to fix it? The xls report will not be used to printing, just to use excel funtions. If I want to print it, there's and option to generate it as PDF. Here's the code I use to set Jasper parameters for the xls report: Code:JExcelApiExporter exporterXls = new JExcelApiExporter(); exporterXls.setParameter(JRExporterParameter.JASPER_PRINT, impressao); exporterXls.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,DIR_REPORTS + nomeArq); exporterXls.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE,java.lang.Boolean.TRUE); exporterXls.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporterXls.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.FALSE); exporterXls.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE); exporterXls.exportReport(); This is the last problem to finish my xls report, please, anybody help! Thanks!

This property is already checked. The row is stretching. However, it's not stretching enough, and I don't know why nor if it is possible to make it stretch more. ]http://img384.imageshack.us/img384/2695/lineszv6.jpg :(

Thanks wbizzare, that should solve the first problem. Any hint how to deal with the second problem? ]http://img107.imageshack.us/img107/8993/linhapj0.gif It happens with every single cell that brings a bigger text than one line :(

Hi guys! First of all, sorry my bad english, I'll try to make it as clear as I can :) I have an application wich needs to generate reports in PDF, HTML and XLS (Excel) formats. When I try to generate in PDF or HTML, it works well, like this: ]http://img186.imageshack.us/img186/5210/pdfwb3.jpg The same report, however, is shown like this when I try to generate it in XLS (Excel): ]http://img441.imageshack.us/img441/5282/xlslc1.jpg As you can see, there are two problems I really need to resolve as soon as possible: 1) It creates a lot of small empty rows and columns. Note that before row 15 there are about 3 useless rows. The same happens after column A, and in a lot of other places. 2) When the text in "Label 1" rows are big enough to be in more than one line, the row does not fit the lines height. Does anybody know how to fix this? Here's the code: Code: The report template is XML (iReport). Thanks!

Hi, first of all, sorry by bad english :P I have this xml report on iReport: ]http://img45.imageshack.us/img45/8766/rep1sd0.jpg $F{INFORMACOES} and $F{INFO2} are passed by JavaBeans, and they are textField fields. Label 1 and Label 2 are staticText fields. My problem is: when the text on $F{INFORMACOES} has only one line, the $F{INFO2} and its label (Label 2) are ok, like this: ]http://img520.imageshack.us/img520/8822/rep2fs4.jpg The problem is when $F{INFORMACOES} has more than one line: I know how to make the field under it ($F{INFO2}) float and adjust its top position (right click, properties, Position Type = Float) but that happens to the Label 2: ]http://img518.imageshack.us/img518/2998/rep3fc0.jpg As you can see, the Label 2 does not align with $F{INFO2}. It should look like this: ]http://img518.imageshack.us/img518/8577/rep4nd1.jpg Is there a way to Label 2 "top position" and $F{INFO2} "top position" to be always the same (i.e. make them both float when $F{INFORMACOES} overflows)? Thanks! Post edited by: overday, at: 2007/05/18 17:55