By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Subreport not displaying

P: n/a
I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.

Thanks.

Aug 13 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Sounds like 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.
Fix the Link Master Fields and Link Child Fields (on the Data tab of the
Properties box, while looking at the Properties of the subreport control.)

--
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.
"Coll" <co*********@hotmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
>I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.

Thanks.
Aug 13 '07 #2

P: n/a
On Aug 13, 9:18 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Sounds like 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.
Fix the Link Master Fields and Link Child Fields (on the Data tab of the
Properties box, while looking at the Properties of the subreport control.)

--
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."Coll" <col_mcma...@hotmail.comwrote in message

news:11**********************@q75g2000hsh.googlegr oups.com...
I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.
Thanks.- Hide quoted text -

- Show quoted text -
I added the subreports up by dragging them into the main report. I
don't have anything in the link masterfields and link child fields for
any of the subreports. Not sure what should be there if anything.

Aug 13 '07 #3

P: n/a
You want the subreport to show only the records that match the record in the
main report. Therefore there is a field in the main report that matches a
field in the subreport.

Set the Link Master Fields is the name of the field in the main report, and
Link Child Fields to the name of the matching field in the subreport.

--
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.

"Coll" <co*********@hotmail.comwrote in message
news:11**********************@57g2000hsv.googlegro ups.com...
On Aug 13, 9:18 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>Sounds like 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.
Fix the Link Master Fields and Link Child Fields (on the Data tab of the
Properties box, while looking at the Properties of the subreport
control.)
"Coll" <col_mcma...@hotmail.comwrote in message
>>
news:11**********************@q75g2000hsh.googleg roups.com...
>I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.
Thanks.- Hide quoted text -

- Show quoted text -

I added the subreports up by dragging them into the main report. I
don't have anything in the link masterfields and link child fields for
any of the subreports. Not sure what should be there if anything.
Aug 14 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.