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.

is it possible or i'm on wrong way ? i need this option, please help. :( i want that sum ammount and other table results on summary band, also i have additional information about report also on summary band. is there is no enough space on page for summary band this move on a new page, which is very bad for me. sum ammount and count of report is on the next page is bad :( sorry for my bad english, Any other idea will be appreciated. _________________________ Regards, Paata Lominadze Post Edited by Paata Lominadze at 02/01/09 11:16

hi all, i'm trying to split summary band, but it's impossible . i have no select summary on a new page and also i have selected split allowed for summary band, but there is no any reaction. i'm trying this for a 6 month but, i have no result :( i tried all version from 3.0.1 to 3.1.3. is it possible anyway ? i thing everybody needs this option. anybody can help me ? Regards, Paata Lominadze.

hi all, i'm trying to split summary band, but it's impossible . i have no select summary on a new page and also i have selected split allowed for summary band, but there is no any reaction. i'm trying this for a 6 month but, i have no result :( i tried all version from 3.0.1 to 3.1.3. is it possible anyway ? i thing everybody needs this option. anybody can help me ? Regards, Paata Lominadze.

upppppppppppppppppppppppppppppp maybe someone had problem like this :(

anyone knows if we buy this product is it possible to resolve this problem ?????

i found similiar post on this forum : http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=201 but link which is shown there is not correct :( i tried to do this into Crystal Reports and it works fine, there is "Keep Together" flag. is this task so difficult or nobody has similiar task ? any idea will be appreciated. ___________________ Regards. Paata Lominadze Magticom LTD.

is it possible to crate splittable summary band ? i set "Summary on a new Page" property to false !!!!!!!!!!!! also "Split allowed" property is true. can anybody help me? i want that summary band must be after detail (after data), becouse i have total sum fields on summary band, but if the space on page enough for my summary band it moved on the next page with total and other my fields which is very very bad. how i fix this problem ?

is it so difficult tu use splittable Band ? is anybody have problem like this ? any idea will be greatly appreciated. _______________________ Paata Lominadze Magticom LTD

why i need to split summary band 1. i have total sum field on summary band and i want that this field must be located after detail ends, after this i have many fields addresses, bank parameters and so on , if there is enough space for summary on page there is no problem, but is space is not enough than all summary band moved on next page with total sum and all of it's parameters. is this so difficult job ? i found huge posts about this problem but could not found any resolves. greatly appreciated for any idea, ___________________ Paata Lominadze Magticom LTD. Georgia.

i know that is possible by print when When Expression and i wrote code like this : new Boolean($V{PAGE_NUMBER}==$V{PAGE_COUNT}) but is not working what i did incorrect ? how i can do it ? __________________ Regards Paata Lominadze Magticom LTD