Nested Sub Reports - is it possible?

[Former Member]

Hi, Please could someone tell me if it is possible to have a sub report within a sub report. I have tried without success. If not what is the alternative? Thanks in advance

Amir

[former_member11696]

Before you go and submit to Idea Place think about this...

Report Design Example:

Main report returns 100 values which are linked to the first subreport. Query sent to the DB for the first 100 values and passed to the subreport, for each value returned a new query is sent to the DB for each value returned by the main report.

101 queries processed by the DB server.

Now say you pass that value into another subreport within the subreport....

Original query sent from the main report, the first value is then sent to the first subreport and then that value is sent to the third subreport.

1 -> 1 - > 1, in total you have:

1 -> 100 -> 100 or 1 * ( 100 * 100 ) = 10001 queries being processed by the DB Server.... And this is simplied, image it your main report returned 100,000 values....

So no, the whole point of using subreports is to use them for different data sources. You can filter your data and use Groups in the place of subreports, then you are unlimited ( sort of ) as to how many drill downs ( subreports ) you can go....

Thanks

Don

[ido_millet]

In some cases you can create database Views that remove the need for subreports.

Otherwise, while Crystal doesn't support subreports withing subreports, at least one of the 3rd-party Crystal Reports schedulers listed at http://kenhamady.com/bookmarks.html allows you to achieve multiple levels of nested content using two different approaches (merging or embeded content in pdf exports).