Subreport problems when larger than page.

[brettatexplace]

I have a report with multible subreports in it (upto 18 subreports in access97). When the pages format with little data in the subreports (so that it all fits on one page) it works great, but if the subreports want to push onto the next page because it has lots of info, the report generation seems to hang at the formatting pages stage. Has anyone had this problem too and do you know of a solution other than not using subreports and printing everything separately using VBA.

 

[Zirak]

I'm not sure if this will solve your problem.
I guess you have memo fields, set the "CanGrow" property of those fields, or the detail section of your subreport to "yes".

I personally don't like subreports, instead of using subreports I join the recordsource query, then create a report in design veiw and drag and drop the fields,
then I manually group them and create a header for each grouping. I think its much better this way.

Good luck.