Sub Report Group Header

[lcsmoothey]

I have a report (A) that contains a sub report (B) in that then contains 6 unrelated sub reports listed one after the other (C to H) (only 3 levels of nesting). The lowest level sub reports (C to H) make my sub report (B) go over more than one page.

After reading several forums/posts, I have used a Group Header in my sub report (B) to get the same heading on each of the pages rather than leaving it to the standard Page Header. However, for some reason Access seems to think my sub report (B) has an extra blank page at the beginning and shows this Group Header twice at the start of the first page.

I have checked this by starting a new blank report, setting up the Group Header, and then adding each of the sub reports (C to H) in turn, doing a print preview in between each addition. It all looks fine with the group header only showing once at the top of the page until I add the sub report that forces a 2nd page to appear. As soon as it goes over 2 pages, the Group Header duplicates at the top of the first page (it does also show once at the top of the second page).

I have selected not to show the Page and Report header sections just to rule out the possibility those were interferring.

Any thoughts?

I am using Access 2003.

 

[vbaInet]

6 sub-reports sounds a bit too much for on report? Could this be a normalization problem?

In any case, check the Force To New Page properties of your sub reports C-H and ensure they aren't set to do so.

And welcome to AWF!

 

[lcsmoothey]

Thanks for the welcome and suggestion. I have checked and all the Force New Page properties on all Report Headers and Details are set to None.

The 6 subreports are only small and the report (B) is only about 1.5 pages. I didn't think there would be a problem with this since colleagues have got far more subreports on some of their databases. None of them have come across this issue I am having though.

So do you suggest reducing the number of subreports on the report (B) and maybe splitting (B) into 2 smaller reports?

 

[vbaInet]

Sub reports can be quite slow . It would depend on how much data you're pulling anyway

Have you got any grouping in subreport B? Are the 6 subs in synch with B via the Link Master-Child properties?

 

[webbeliz]

I'm not sure if you ever found your fix. But in case someone else is looking at this site for the same issue, I thought it worth posting.
I've no idea why Access does this, but I have had the same thing happen a number of times.
It appears that it will always happen on an =1 group header, if you have no underlying query/table linked to the report (eg. when the report is just acting as a "shell" for a number of subreports).
If you add a table or query as underlying source on the report (even though you aren't actually using it), the problem goes away.

Hope this helps!