Linking a report with a subreport.

  • Thread starter Thread starter Sergio Juan
  • Start date Start date
S

Sergio Juan

Hi.

I am modifying a report done by a coworker. The report is generated from a
query and contains a subreport based in a different one. I have tried to
link both of them, but so far I have not succeeded. I have found some
examples in the web, but I'm still new to Access and maybe I'm missing
something, because they does not work. So, I'll tell the steps I followed so
you can point me the errors (or give me any new idea).

Let's see R1 the main report, Q1 its query, R2 the subreport , Q2 its query,
FIELD the field to use to join both R1 and R2 and TABLE the name of the
table where FIELD is.

* In the parent repord, I do nothing.
* In the sub report, I go to the query and go to the Properties list,
putting in both the Child/Parent link text boxes FIELD (that is, without
telling neither query nor table name).
* When I close and save, no error is shown.
* When I see the report, the subreport contains all of the values of the
query, without filtering to only the related to the value at the report.

Thanks In Advance. Sergio.
 
Sergio said:
I am modifying a report done by a coworker. The report is generated from a
query and contains a subreport based in a different one. I have tried to
link both of them, but so far I have not succeeded. I have found some
examples in the web, but I'm still new to Access and maybe I'm missing
something, because they does not work. So, I'll tell the steps I followed so
you can point me the errors (or give me any new idea).

Let's see R1 the main report, Q1 its query, R2 the subreport , Q2 its query,
FIELD the field to use to join both R1 and R2 and TABLE the name of the
table where FIELD is.

* In the parent repord, I do nothing.
* In the sub report, I go to the query and go to the Properties list,
putting in both the Child/Parent link text boxes FIELD (that is, without
telling neither query nor table name).
* When I close and save, no error is shown.
* When I see the report, the subreport contains all of the values of the
query, without filtering to only the related to the value at the report.
Click to expand...

It's not that complicated. The subreport control on the
main report has two properties, Link Master/Child that cah
be used to specify the linking field(s). Check Help for
details, but it should be a simple as placing FIELD in both
properties.
 
Back
Top