Are nested subreports possible?

[lauriebizz]

Crystal 9 and SQL

Ok, I've created a report with a sub report, linked ledger fields, grouped by like fields and did the formula thing to sum the two totals together - I must say I'm proud of myself... I didn't even have to ask

On to the stupid question... I have another weekly report -I placed the report mentioned above in an additional detail section, but the linked sub report is gone... can you have a sub report within a sub report? Or am I asking too much?

Thanks-
Laurie

 

[synapsevampire]

Unfortunately not, one level of nesting is all that is supported.

Subreports in detail sections should be avoided anyway as the sql fires for every row in the details.

Try to build out a better datasource, or use the Add Command to create SQL which returns everything in one recordset.

-k

 

[lauriebizz]

Thanks for the response. I'm currently studying SQL, so maybe I'll eventually figure it out.
Thanks-
Laurie

 

[synapsevampire]

If you check the Database->Show SQL Query in Crystal, it will show you the SQL being used.

If you then do so for each subreport, you will have all of the sql being used.

-k

 

[lauriebizz]

Makes sense...
Thanks-
Laurie