Linking subreport to report

[Double A]

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.

 

[Tom Wickerath]

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
__________________________________________

 

[Double A]

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.

 

[Tom Wickerath]

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:

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.

 

[Albino]

https://www.habbo.nl/register?partner=mgm2&isp=318495&code=d9fe2b093bb78424587b323d7e1aaded

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