I created static report with Pentaho Report Designer using 3 subreports.
For second and third subreport I set "pagebreak-before" option to 'true', to have each of them on the new page.
It influences PDF and also Excel output. See attached screenshots.
Is it possible to set page break only for PDF export type, but keep all subreports in Excel export type on one sheet?
I tried to set "page-mode=stream", but it does not work for Excel outputs (97 nor 2007).
Thank you and regards,