[Multiple Group Headers On Same Line]

Thanks.  Unfortunately that won't work for me as I want to get the subtotals for each level of grouping.  I tried putting all the groups in the same band, but oddly then I got output that looks like this:

Year  Month  Category 1

Year  Month Category 1

                     Category 2

 

I don't know why Jasper is inserting an extra line with the groups on it.

[Multiple Group Headers On Same Line]

I am creating a Jasper report programmatically using Java code.  Everything is working well, except I would like to change how multiple group headers are displayed.  I have three groups to summarize financial data:  Year, Month, and Category.  Currently these are displayed in the report on separate lines like this:

Year

Month

Category

I would like these group headers to appear on the same line, like this:

Year  Month  Category

Is there any way to do this?

[Excel Export Currency Column Issue]

I am having a problem with currency fields in an Excel export.  I have the following pattern in my Jasper report for the currency field:  ¤#,##0.##   I am using the REPORT_LOCALE parameter to tell Jasper to use locale to format the currency field, and I use the setDetectCellType(true) option in the JRXlsxExporter configuration.  But when I open the Excel spreadsheet, the column values display like this:  ¤2,722.48.

I am using the jasperreports-6.18.1 jar.

[Replacement for JRHtmlExporterParameter.PAGE_INDEX]

I want to use the HtmlExporter to export a specific report page.  Currently I can use the JRHtmlExporterParameter.PAGE_INDEX to do that, but it is deprecated.  I can't find a way to do this using the replacement classes ExporterInput, HtmlExporterConfiguration and HtmlExporterOutput.  Is there a way to do this that is not deprecated?