Crosstab Report export to excel

[monc]

Hello,

I’m creating a report using the Crosstab Component and I would like to export it in excel (xlsx or xls) format.

The report is ok on preview and when exported in PDF but have a problem with formatting when exported in Excel as you can see below.

(PDF Format)

(excel format)

Any tips on how I can format the crosstab so it looks good when exported in excel?

Thanks and Regards,
Mon

[josborn]

That’s kind of the nature of the beast. Reports that don’t have a simple table structure get mangled when you export them to formats like excel or csv. Your left most column is the likely culprit, if you could simply repeat those values for each line it might come out better.