Hi, I am facing a similar problem
I am using pentaho report designer 6.
I am creating an excel report with multiple sheets in it with the same query to all the sheets using cross tab in each sheet.
Here the report is loading to 26% and then it is not loading from there.
When i tried generating the report without crostab it is working fine and data is loading into int.

Is there any solution to resolve this issue. Please help me in this.