I have a simple report that runs a subreport with a crosstab. The simple outer report sets the Excel sheet name and then runs the subreport passing a parameter from the main report. The goal is to have each crosstab on each own named spreadsheet tab.
When I run the report, the iReport internal preview looks fine. I get every crosstab. Exporting to PDF also works. HOWEVER, exporting to any Excel format does not work. I only get some of the crosstabs exported.
Does anybody have any idea how to fix -- or at least how to debug what is going wrong?
Thanks in advance.
eraskin at paslists dot com
Certainly. Sorry in advance for the long post. You will see that the preview screens show all the crosstabs but the export worksheets do not. There are more pages, but I think these are enough to illustrate the problem.
Here goes - iReport 5.0.1 previewer page 1:
XLSX Export Tab 1:
iReport preview page 2:
XLSX Export tab #2:
iReport preview page 3:
XLSX Export tab 3:
iReport preview page 4:
XLSX Export tab 4: