When Exporting a Crosstab Adhoc View to Excel, the Second Column is Partly Perged

Issue Description

Customer created an Ad Hoc View Crosstab, enabled Crosstab Column Header per article

https://community.jaspersoft.com/wiki/missing-column-titles-when-exporting-ad-hoc-crosstab-view

and exported the view to MS Excel. As a result, the second column is partially merged with the first column:

End users usually don't want this column (the seconds one), so they need to delete it every time after they do the export.

How to avoide such the behavior?

Resolution

Crosstab report generator creates an extra Frame element with incorrect size/position which leads to creating an extra column.

A possible solution/workaround is to create a report from the affected Ad Hoc View, modify it in Studio and correct Frame element size or position:

Solution tested with TIBCO JasperReports^® Server v.6.4.0

Ref. Case 01560446