paatal

uuup :(

hi again. did you see my files lucianc? ____________________ Regards, Paata Lominadze. Magticom LTD.

hi again lucianc here is my jrxml and xls Thank you very much again :) ____________________ Regards, Paata Lominadze. Magticom LTD.

hi again, i tryed everything but no success. here is my code : JRXlsExporter exporter = new JRXlsExporter(); ByteArrayOutputStream xlsReport = new ByteArrayOutputStream(); exporter.setParameter(JRExporterParameter.JASPER_PRINT_LIST, jasperPrintList); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, xlsReport); exporter.setParameter(JRExporterParameter.OUTPUT_FILE, path); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, name); exporter.setParameter(JRExporterParameter.IGNORE_PAGE_MARGINS, Boolean.TRUE); exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE); exporter.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE); exporter.exportReport(); but margins still appeard ,,, what is here incorrect IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS didn't help me .. i need to decrease size of margins or remove (left and right) but i can't :( ___________________ Regards, Paata Lominadze. Magticom LTD.

any idea lucianc ??? Thank in advance.

Thanks for reply. I use JR 3.5.2 but i tried also older versions. ____________________ Regards, Paata Lominadze. Magticom LTD.

is there any workaround ???

is it possible ?

hi again :) i have report for example "Invoice Report" it works fine, now i want to export invoices into one excel file. is it possible ? how ? i want that one sheet contains one report. any idea will be appreciated _________________________ Regards Paata Lominadze Magticom LTD.

hi all, is it possible to remove margins from Excel file ? or change margin size ? i tried to do this but it does not helkp me : JRXlsExporter exporter = new JRXlsExporter(); ByteArrayOutputStream xlsReport = new ByteArrayOutputStream(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, xlsReport); exporter.setParameter(JRExporterParameter.OUTPUT_FILE, path); exporter.setParameter(JRExporterParameter.IGNORE_PAGE_MARGINS, Boolean.TRUE); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, name); exporter.exportReport(); byte bytes[] = xlsReport.toByteArray(); xlsReport.close(); OutputStream ouputStream = new FileOutputStream(path + File.separator + name); ouputStream.write(bytes, 0, bytes.length); ouputStream.flush(); ouputStream.close(); after this variable isIgnoreMarginPage into exporter instance is false ... why ? _____________________ Regards, Paata Lominadze. Magticom LTD.

if you have only one minute please look into my report which is attached here. maybe then it will be clear what i want. Post Edited by Paata Lominadze at 02/11/09 16:54

:( :( :( uup.

any idea ? is this bad pattern ? is it possible ? or maybe problem described incorrectly ? __________________ Regards, Paata Lominadze

Thank you very much for your reply. i did everything what you told me, my first problem resolved. sum field is always on last page of report after data. but i want another one task. if you have only one minute look at my example report wich is attached here.

thank you very much for your post. i need to achieve this case : i have simple report with data, this table contains column "Amount". i need to apply sum of ammount on the last page of report, not on all pages. i took simple text field and place it on summary band under the "Amount" column. 1. Am I right ??? if i am wrong, where it should be placed ?? then also i need to place additional parameters about report on the summary band . ex : bank information, address, town, country and so on. i want that this information must be on the last page after report. for them i use also text fields. result : i have one "Amount" text field on summary band(On the top of band) and many text fields for information (15 fields). problem is that, if page does not have enough space for whole summary band after data, band goes to the next page with all of it's fields. for example on the last page i have enough space for "Amount" but there is no enough space for whole band, i need that amount field must be in the end of report data, Sorry for my explanation. Regards, Paata Lominadze.