Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
subreport limitations 1
- Thread starter easaw
- Start date
No, A subreport cannot contain a subreport.
Generally speaking, the downside of using subrports is performance. If you have a specific report in mind please let us know what your desired output should be, some idea of the database layout, data type, etc. and we can explore if a subrport is a good idea for your applicaiton or not.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Generally speaking, the downside of using subrports is performance. If you have a specific report in mind please let us know what your desired output should be, some idea of the database layout, data type, etc. and we can explore if a subrport is a good idea for your applicaiton or not.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
synapsevampire
Programmer
Subreports are generally slow.
If you place a subreport in a group footer, each time that group footer iterates, the subreport will fire, meaning that many SQL statements.
I only use subreports to insert unlinked data sources into a main report, so in essence it's multiple reports within a container report.
Since you have CR 10, you can instead pass the SQL to the database (use the Add Command), which could contain a subquery, which is generally why people use subreports.
You might also use a View or a Stored Procedure on the Oracle database, which is generally the best idea because this data source would then be available to other reports/processes.
Please post the specifics if you have specific concerns or question.
-k
If you place a subreport in a group footer, each time that group footer iterates, the subreport will fire, meaning that many SQL statements.
I only use subreports to insert unlinked data sources into a main report, so in essence it's multiple reports within a container report.
Since you have CR 10, you can instead pass the SQL to the database (use the Add Command), which could contain a subquery, which is generally why people use subreports.
You might also use a View or a Stored Procedure on the Oracle database, which is generally the best idea because this data source would then be available to other reports/processes.
Please post the specifics if you have specific concerns or question.
-k
-
1
- #4
chelseatech
Instructor
Subreports can be used to solve many interesting problems.
I'm not sure what you mean by "Slow". If a subreport solution gets you to your destination, and not using one can't get you there, then "slow" is not relevant. Any time is faster than "never".
I've found several situations where a subreport makes the report faster.
1) I replaced a large drill down report with an on demand subreport. Because we were only looking at selected transactions in the subreport, the main report had a lot less data to process and was a lot faster.
2) A competitor wrote a 160 page stored procedure that was impossible to support. I replaced the report with one that used 6 subreports and it ran twice as fast.
Get your linked fields right in the subreport and it can really hum along.
Editor and Publisher of Crystal Clear
I'm not sure what you mean by "Slow". If a subreport solution gets you to your destination, and not using one can't get you there, then "slow" is not relevant. Any time is faster than "never".
I've found several situations where a subreport makes the report faster.
1) I replaced a large drill down report with an on demand subreport. Because we were only looking at selected transactions in the subreport, the main report had a lot less data to process and was a lot faster.
2) A competitor wrote a 160 page stored procedure that was impossible to support. I replaced the report with one that used 6 subreports and it ran twice as fast.
Get your linked fields right in the subreport and it can really hum along.
Editor and Publisher of Crystal Clear
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question