Crosstab in a subreport

[Janezz]

Hello,

I have a report in which I have to show two unrelated datasources. I put the first datasource in main report, the second in a subrepot, the subreport is put in report footer of a main report. Main report has one group (by sales person) and for each sales person (group) there's a crosstab that shows some summary values. The crosstab sometimes extends beyond the report limit and so horizontal pages are displayed for such crosstab.
The subreport also has a crosstab, but there's always only one crosstab, there's no grouping in a subreport. This crosstab can also extend beyond the page width and here's the problem: because the crosstab is in a subreport the additional columns that are beyond the page width are not displayed.
So I tried another approach: I dropped the subreport, put both datasources in the main report and added crosstab that was previously in subreport directly to the report footer of the main report. Because both datasources are unrelated, I did not establish any link between both datasources and CR warned me that report has multiple entry points which is generally not supported.
Nevertheless, I tried to run the report and it displays as should, but it takes ages to show, it is at least 100-times slower than with subreport approach. I think the problem has something to do with the fact that both datasources are unrelated.

Any other solutions to such problem?

Thanks
Janez

 

[lbass]

Some possible simple fixes would be to uncheck "show cell margins" to minimize the cell space within the crosstab, or use landscape mode and legal paper, or even a printer driver for a very wide printer. Or pivot the crosstabs, if there are fewer rows than columns.

Otherwise, you could potentially wrap the crosstabs, but this is a little more complex and works best if your columns are based on sequential numbers.

-LB