I have a crosstab with six groups in it. I want to export a report in Excel and I need to have ability to expand/collapse on every group level. For example in my attached report template I want to collapse table to Grand Total (1 level), SKU totals (2 level), Country totals (3 level) and so on until Post Code totals(6 level).
I have inserted outline Row Level Properties in crosstab elements (I hope correctly) but I receive such a mess inside exported .xls document.
I have attached it too.
Also while I was experimenting on different ways of putting outline property I noticed that outline doesn't work in my template even only for one Post Code group. JasperReport doesn't group when there is only one element in it but I need that too.