Subreport not displayed in parent Preview or Print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle - 22 Jul 2005 15:55 GMT

I have an Access 2000 report with several subreports which have their
own queries. All of the subreports display when I preview or print the
parent report, except one. It is set as Visible with CanShrink set to
No. If I preview the sub report on it's own all is displayed (data is
present), but it won't show when I preview or print the parent report.

Has anyone encountered this issue before? Any advice or suggestions
would be appreciated!

Thank you,
Michelle

Reply to this Message

Allen Browne - 22 Jul 2005 16:03 GMT

Chances are the subreport is incorrectly linked to the main report.

Open the main report in design view.
Right-click the edge of the subreport control, and choose Properties.
On the Data tab, what is in LinkMasterFields and LinkChildFields?

Access will choose the subreport records based on matching these fields. If
the properties are set wrongly, no records will match, and so the subreport
won't show anything.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have an Access 2000 report with several subreports which have their
> own queries. All of the subreports display when I preview or print the
[quoted text clipped - 7 lines]
> Thank you,
> Michelle

Reply to this Message

Michelle - 22 Jul 2005 23:47 GMT

Thank you for your reply,

Fortunately I have solved the issue - two of the sub reports were
pointing to the same query - i changed one of them to point to
something else and that seemed to force both sub reports to appear when
previewing & printing from the VB application (tho they are still not
showing in layout preview).

Thanks,
Michelle

Reply to this Message