Question Re: Nested Sub Reports - is it possible? in Technology Q&A

Nested Sub Reports - is it possible?

Former Member — Tue, 21 Feb 2012 07:55:37 GMT

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

Re: Nested Sub Reports - is it possible?

aasavaribhave — Tue, 21 Feb 2012 13:57:27 GMT

I don't think this functionality is available even in latest CR. So basically you cannot have a subreport within a subreport. If you try to insert a subreport that has a subreport, the ineermost subreport is not rendered when the report is run. This is by design. You also cannot link 2 subreports with one another.

You may want to submit this as enhancement requests at [Idea Place|http://ideas.sap.com]

Re: Nested Sub Reports - is it possible?

Former Member — Tue, 21 Feb 2012 15:11:53 GMT

For a suggestion / alternative approach, please post your query to the [SAP Crystal Reports Design|http://forums.sdn.sap.com/forum.jspa?forumID=313] forum.

Ludek

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

Re: Nested Sub Reports - is it possible?

former_member11696 — Tue, 21 Feb 2012 21:48:07 GMT

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

Re: Nested Sub Reports - is it possible?

ido_millet — Tue, 21 Feb 2012 22:12:34 GMT

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).