Overlapping Subreports - Ms Access 2007

[Darragh]

Hi all


I've encountered what seems to be a bug in Access 2007. When viewing a
main report with a number of subreports in REPORT VIEW, some
subreports will refuse to grow appropriately, meaning the subreport
'below' it overlaps. It looks fine in print preview however.

A quick google around the internet reveals no appropriate solutions.
Wondering if anyone knows if this is a bug in Ms Access 2007? I'm
positive this never occured in earlier versions.

I've set the appropriate CanGrow and CanShrink on the main reports
controls for the subforms. Even places page breaks between the
subreports will not stop this behaviour.

Similar problem has been illustrated in many different places with no
solutions for example here: http://www.utteraccess.com/forum/Subreport-grow-t1948651.html

Any help appreciated

Regards

Darragh Murray

 

[a a r o n . k e m p f]

I dunno dude.. I sure don't have those problems

Seems to me like anyone with a clue moved to SQL Server Reporting
Services a long time ago

 

[Tony Toews]

I've encountered what seems to be a bug in Access 2007. When viewing a
main report with a number of subreports in REPORT VIEW, some
subreports will refuse to grow appropriately, meaning the subreport
'below' it overlaps. It looks fine in print preview however.

Do the controls overlap or touch each other? If they do can you
reposition them so they're just a hairline apart from each other?

Also presumably these aren't on the header or footer. It's been my
experience that header and footer sections don't grow like report
sections would.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[Darragh]

Do the controls overlap or touch each other?  If they do can you
reposition them so they're just a hairline apart from each other?  

Also presumably these aren't on the header or footer.  It's been my
experience that header and footer sections don't grow like report
sections would.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages -http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
  updated seehttp://www.autofeupdater.com/

Hi Tony

Thanks for your reply.

No they don't overlap.

Its only in report view. View the report in print preview and it
positions fine. Could be a bug.

Darragh

 

[Tony Toews]

Its only in report view. View the report in print preview and it
positions fine. Could be a bug.

If you can make a simplified case, that is a few tables with a few
records and a report with subreports illustrating this problem I wil
forward to my fellow MVPs for discusion and comments. If no
resolution or suggestions I'll then forward this to Microsoft.

Best would be to zip it and put the file somewhere public with a link
for downloading. Skydrive would work for this.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[a a r o n . k e m p f]

SQL Server Reporting Services explicitly complains about overlapping
controls, it says that they're not supported in all rendering
extensions