Multiple copies of reports

  • Thread starter Thread starter stevens
  • Start date Start date
S

stevens

I have a report with data from a one table, and a subreport with data from
the many table. Problem is when I go to print the report, it prints the
whole report for each item in the subreport. Even though all items in the
subreport appear on the report, and I only need one copy of the report, a
page is printed for each item in the subreport. How can I keep this
behaviour from happening? Thanks.
Steve
 
To correct the linking between main and subreport:

1. Open the report in design view.

2. Right-click the edge of the subreport control, and choose Properties.

3. On the Data tab of the Properties, box, check the LinkMasterFields and
LinkChildFields properties.

LinkMasterFields should have the name of the primary key field/control from
the main report, and LinkChildFields should have the name of the foreign key
field/control in the subreport.
 
Thanks, Allen for responding, but this did not help. I checked the master
and child links, and everything was fine according to your instructions.
This is actually the second time I have had this problem. I think the thing
that solved it before was to choose ALL the fields needed in the report,
even from the subreport, at the time of creating the report with the wizard.
The wizard somehow sorts everything out. I have to do a massive amount of
re-formatting after the wizard runs, but it all seems to come out right. I
just wondered if there was a way to solve this problem without having to
re-do the entire report.
Steve
 
From your description, maybe you wanted a different result, based on a query
instead of a subreport?

Perhaps you could create a query containing the 2 tables, and drag just the
fields you want into the grid. Then ask the wizard to build a report based
on the query.

Not sure I have understood your needs clearly.
 
Back
Top