multiple unrelated selects in one crosstab report

[Former Member]

I have 10 different select SQL statements that all use the same dynamic parameters but have different answers. I want to be able to run all 10 different select SQL statements from one report with 10 report footers, The issue here is the report is getting timed out after 20 mins.I tried creating subreports but couldnt get the expected results because of crosstab limitations. FYI : Crystal crosstab properties are limited to the main report and do not expand horizontally in sub reports.

[Former Member]

Hi Dell,

I tried the option you gave me, turning on "Dissociate Formatting Page Size and Printer Paper Size" in main report and subreport, I still don't see the sub reports extended columns.

[Former Member]

I'm using crosstab in all the 10 reports. I have tried creating subreports but didn't work,as I mentioned in my earlier post The crosstab in the main report automatically generates the necessary horizontal pages when the crosstab extends beyond the first page. In the subreport, the crosstab should also generate horizontal pages. It does when it is run independently of the main report as a report by itself. But when it is added as a subreport to the main report, it only displays the first page and does not display/generate the horizontal pages that go with the subreport crosstab.

[DellSC]

And you'll also want to play with the page settings in the main report and subreports. Specifically, use a custom page size that is wider than what you think your cross-tab will be and turn on "Dissociate Formatting Page Size and Printer Paper Size" . Also, I would create 9 subreports and a cross-tab in the main report for one of the queries. Put the cross-tab and all of your subreports in separate report footer sections.

-Dell

[former_member11696]

Add 10 subreports, CR is not designed to have multiple data sources in the main report.