I have a master report with 4 sub reports. Outputting to Excel format. In the master report, each sub report is in a separte detail band. These detail bands are separated by other detail bands, each with a single empty static text element with net.sf.jasperreports.export.xls.break.after.row=true to force the following sub report to a new sheet.
In each subreport I have net.sf.jasperreports.export.xls.freeze.row.edge=Bottom set on one of the labels in the Column Header band. On output, only the first two sheets have the rows correctly frozen. The rows on the last 2 sheets are not frozen.
Attached are the report definitions.