Printing/Previewing a Order

M

Mark

Hi,

I have created a main form that has a subform. In the sub
form I input the line items. Each Order on the main form
can have multiple line items.

When I print preview an order with one input line I
receive a one page report.

When I print preview an order with 4 input lines I receive
4 identical pages. 3 input lines i get 3 pages of
identical data.

Does anyone know how I can just get the report to print
out just once.
 
D

Duane Hookom

You should be printing reports not forms. Your main report should not
contain the same level of details as the subreport.
 
M

Mark

Hi Duane,

I have attached a print icon to the form that contains the
report I want to run. I am printing the report through the
from. It comes up with the correct record but as I tried
to explain before wherever I have more than one line item
in the subreport the report prints the identical page.

EG My query for the report comes up with the data I
require eg Order No: 1 Qty 5 Desc Coke
Order No: 1 Qty 3 Pesi.
Even this is only one record when it prints it prints its
twice.

Hopefully this make sense
Mark
 
D

Duane Hookom

Let me put it another way... check the record source of the main report.
Does it contain just order summary information or do you also see Qtys?
 
M

mark

Sorry I been away the last 2 days. The main report only
includes summary information. The sub report contains the
qty and line item iformation

Thanks Mark
 
G

Guest

Please disregard my previous reply. The record source is
my query. My query contains both qty line and summary
information.

Eg

Order Desc qty price
14 cans 1 1.00
15 tins 1 1.00
15 cans 1 1.00

Order No is the primary key> Order No 15 has 2 lines in
the subform. Order No 14 has only 1 line. When I print the
order the report is fine but I get two pages of identical
information
 
D

Duane Hookom

Did you understand that the order details must be removed from the main
report's record source?
 
Top