Format excel template such that parent band rows are "merged"

Support
,
#1

Jmix version: 1.4.4
Jmix Studio plugin version: 1.5.1-231
IntelliJ version: IntelliJ IDEA 2023.1.5 (Ultimate Edition)

Here is an example of what I’d like to achieve:

I have a report with an excel template. In addition to the Root band, the data structure of the report has three bands: StateBand is parent to CityBand, which is parent to AddressBand. The excel template has named regions set up as shown in the first image attached. The resulting report is formatted like the second image attached. I would like to achieve what is shown in the third image attached. Is this achievable without using JasperReports?

example template

current

goal

#2

Hi Bryan,
Unfortunately, with an Excel template, grouping cells in this way cannot be implemented. Jasper or HTML may be more suitable for such a report.

Regards,
Sergey

1 Like
#3

Thank you for the information. I’m new to the forums, so I’m not familiar with the procedures. Is it correct to mark your post as “solution” since you have given me a definitive answer, even though what I was seeking to do cannot be done?