Too many pages in report

[Guest]

I have created a report that prints a main section that has the customer
information, including a serial # for each piece of equipment, it also prints
a subreport that reports the components used by that customer. When I have
just the customer and one component, it prints fine. When I add components
associated with a, a page for each component prints out. If the customer has
20 components, I get 20 pages. I have tried different methods of creating
the report, but always get the same results.
The last attempt is simple: I created a macro who's action:OpenReport ,
view: print, Where Condition: [SystemSn]=[Forms]![EquipColSheet]![SystemSn]
Is there any way to limit the number of pages printed? I only need one.

 

[Duane Hookom]

If the components are in a subreport, then remove them from the main report.

 

[Guest]

Right now, the subreports are in the 'Detail' section of the report. Where
would I move them to?

If the components are in a subreport, then remove them from the main report.

--
Duane Hookom
MS Access MVP

I have created a report that prints a main section that has the customer
information, including a serial # for each piece of equipment, it also
prints
a subreport that reports the components used by that customer. When I
have
just the customer and one component, it prints fine. When I add
components
associated with a, a page for each component prints out. If the customer
has
20 components, I get 20 pages. I have tried different methods of creating
the report, but always get the same results.
The last attempt is simple: I created a macro who's action:OpenReport ,
view: print, Where Condition:
[SystemSn]=[Forms]![EquipColSheet]![SystemSn]
Is there any way to limit the number of pages printed? I only need one.

 

[Duane Hookom]

I would leave them in the detail section but remove the component table from
the main report's record source.

--
Duane Hookom
MS Access MVP

Right now, the subreports are in the 'Detail' section of the report.
Where
would I move them to?

If the components are in a subreport, then remove them from the main
report.

--
Duane Hookom
MS Access MVP

I have created a report that prints a main section that has the customer
information, including a serial # for each piece of equipment, it also
prints
a subreport that reports the components used by that customer. When I
have
just the customer and one component, it prints fine. When I add
components
associated with a, a page for each component prints out. If the
customer
has
20 components, I get 20 pages. I have tried different methods of
creating
the report, but always get the same results.
The last attempt is simple: I created a macro who's action:OpenReport
,
view: print, Where Condition:
[SystemSn]=[Forms]![EquipColSheet]![SystemSn]
Is there any way to limit the number of pages printed? I only need
one.

 

[Guest]

Thanks for your help on this. I don't know where I got the idea that the
component table had to be in the report's record source.
You have saved me from a lot of frustration.

Thanks and best regards
Scooter

I would leave them in the detail section but remove the component table from
the main report's record source.

--
Duane Hookom
MS Access MVP

Right now, the subreports are in the 'Detail' section of the report.
Where
would I move them to?

If the components are in a subreport, then remove them from the main
report.

--
Duane Hookom
MS Access MVP

I have created a report that prints a main section that has the customer
information, including a serial # for each piece of equipment, it also
prints
a subreport that reports the components used by that customer. When I
have
just the customer and one component, it prints fine. When I add
components
associated with a, a page for each component prints out. If the
customer
has
20 components, I get 20 pages. I have tried different methods of
creating
the report, but always get the same results.
The last attempt is simple: I created a macro who's action:OpenReport
,
view: print, Where Condition:
[SystemSn]=[Forms]![EquipColSheet]![SystemSn]
Is there any way to limit the number of pages printed? I only need
one.