Linking subreport to report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Double A - 08 May 2008 04:46 GMT

I set up a report to create an invoice-type report. I used a subreport to
show the payments that have been made. In Access 2000, how do I link the
subreport to the report so that only the payments associated to the customer
will show? I tried looking in the properties, Data like I have done for
subforms and forms, but the child-master options do not show there. Can this
be done?

thanks.

Reply to this Message

Tom Wickerath - 08 May 2008 05:46 GMT

The control that holds the subreport--not the subreport itself--is the one
that has the Link Master Field / Link Child Field properties, just as it is
with a form/subform. In report design view, when you click on this object,
you should notice selection handles in a rectangular shape.

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

> I set up a report to create an invoice-type report. I used a subreport to
> show the payments that have been made. In Access 2000, how do I link the
[quoted text clipped - 4 lines]
>
> thanks.

Reply to this Message

Double A - 09 May 2008 06:07 GMT

Thank you for this info. I was able to link them up properly. Given the
subreport, how would I write the following calculation:

Sum([Cost])+Sum([Discount])-srptPayments.Report!Text9

I want to add the costs, then add the discounts(keyed in as negative
numbers), then subtract the total payments from my subreport. When I try to
use the above expression, the report asks me for the srptPayments parameter.
Do I have the correct expression? How can I perform what I am looking to do
in jy report?

Thanks.

> The control that holds the subreport--not the subreport itself--is the one
> that has the Link Master Field / Link Child Field properties, just as it is
[quoted text clipped - 16 lines]
> >
> > thanks.

Reply to this Message

Tom Wickerath - 09 May 2008 09:24 GMT

Hi Double A,

> Given the subreport, how would I write the following calculation:
> Sum([Cost])+Sum([Discount])-srptPayments.Report!Text9

Try this:
=Sum([Cost])+Sum([Discount])-ContainerName.Report!Text9

where ContainerName is the name of the control that contains the
subreport--this is the same control that you identified previously, which has
the Link Master Field and Link Child Field properties.

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

> Thank you for this info. I was able to link them up properly. Given the
> subreport, how would I write the following calculation:
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message