macivic

This post explain similar problem: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=68388[/code]I hope it help you.[/code]

Thank you Lucian, Those properties works fine. The only restriction is they only can be use with JRPrintElement, and Group isn't an instance of this class. I resolved it adding a line at group footer with line width 0 (invisible). I set the net.sf.jasperreports.export.xls.break.after.row property to true in the line and the report break in each group. I don't know if it was the best solution or you have another suggestion. Miguel

Hi all: I need to export a report into excel format generating a sheet per group, but I don't want to split the group in various sheets. If I set IS_ONE_PAGE_PER_SHEET property to false, the exporter ignore "start on a new page" group property and generate the entire report in a unique sheet. If I set IS_ONE_PAGE_PER_SHEET property to true, the group splitted in various sheets. Any suggestions? Thanks in advance. Miguel