Maximum number of subreport in a single crystal report

building reports crystal reports
1

What is the maximum number of sub-reports can be inserted in a single crystal report in XI.

Thanks in advance.
Senthil
:?:

anbusenthil (BOB member since 2005-05-21)

2

Hi anbusenthil,

I tried by increasing the section space.

The error Occured is " Page Header plus Page Footer is too large for the page".

We could not say the number of sub reports in a singe report because we could change the sub report space to be displayed.

thiyagarajan8 (BOB member since 2004-12-03)

3

I’m considering using subreports but wanted to get some advice/feedback with regard to how this would impact performance time of the report.
The report could generate up to hundreds of subreports, depending on what users enter in the prompts. We’re using CR XI (with universes) and the reports will be posted to the infoview portal for users to run.

example:
Data–>
Bank ID, Bank address-State,
Customer Account ID, Customer Adress-State
(each customer accountID is linked to a BankID, where the Bank’s State and corresponding Customer’s State can differ).

Report prompts: State -> allows users to select the State(s) of the BankID and return all Customer Account IDs and customer Addresses for that BankID.

So my thought was to have the main report show the selected BankIDs (based on the state prompt values), and linked subreports showing the corresponding Customer AccountID and addresses. The main report would pass multiple parameters (BankID as well as others) to the subreport. Given all this, there could be hundreds of subreports generated.

So with regard to performance, would using subreports be a worthwhile option? Also, is there a limitation to how many subreports could be generated from one main report??

cctran (BOB member since 2005-04-21)

4

Subreports definitely effect the performance. Every time the subreport opens it hits the databases. So No of Subreports times database access time. If the subreport brings very less no of rows say 10 it wouldn’t effect much.

DWHUser (BOB member since 2005-08-29)

5

DWH is correct, each subreport will run its own query individually, even if it is the exact same query in each one. So, add all the run times of each subreport and that will be your report run time.

Why do you need to use that many subreports? If they are going against a small amount of data then I wouldn’t worry about it, but if you are running large queries against your Data warehouse, I would try another aproach. Like putting the data in one query and suppressing rows that you dont need based on user input.

Scott Bowers :us: (BOB member since 2002-09-30)

6

thanks for the input. sounds like subreports are definitely not a good option for my report considering we’ll have large amounts of data.
the main reason i was considering subreports was that the query needed to generate my report will be a subquery (from ex. above - bankIDs selected are passed to main query to select customerIDs), so thought subreports would fit. Guess the best option is to let the universe handle the subquery.
thanks.

cctran (BOB member since 2005-04-21)

7

you can also put the subquery in the sql expression fields. you can even then use the sql expression in the selection criteria and if you do a show sql you will discover it all passes over.

Dan Fields :shock:

LANFIELD :us: (BOB member since 2006-05-18)