Skip to Content

multiple unrelated selects in one crosstab report

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Dec 05, 2018 at 07:23 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2018 at 07:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2018 at 09:50 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2018 at 05:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded