Problems - Main report with subreport

[Cosmos75]

I have a report that contains a subreport. The subreport will open on its own fine. But the main report won’t open unless I remove the subreport. Or at least, I wasn’t patient enough to wait for it to open. The progress bar goes straight to 100% then nothing happens, even after 10 mins.

I’ve looked for similar thread and have checked the following common problems
- The Master/Child links are correct.
- No domain aggregate functions, e.g. DMax()]

I tried deleting and removing grouping levels. But what I’ve noticed is that it doesn’t matter if I have three or two grouping levels. What DOES seem to matter is that the ENTIRE subreport can fit on the page. Anyone know why? Is that always the case for subreports?


FYI, my subreport is in the header section of the field that it is linked to. I can't put it in the detail section as it is a detail and summary of data related to the linked field, while the detail section shows a detail and summary of other related data.

Perhaps I should have both sets of data as subreports?

 

[Cosmos75]

With a little more searching, I found the answer!!
- http://www.access-programmers.co.uk/forums/showthread.php?t=49754

But since I need to repeat the header section of the field that the subreport is linked to, the subreport would repeat together with the header section did. So, what I did was to create a duplicate grouping header section and placed the subreport there. The report seems to be looking the way I need it to!