My invoice report generates pages on number of items

[ILIR ISTREFI]

how should I resolve the problem of outputing a single page report.

I have an Inoice report with all informations and sub_report on it with
items informations.
I was based on Northwind database to create most of parts of my database.
Orders Form Is similar to Northwind's one (with a lot of adjustments for my
purposes) and when I click print Invoice I get outputed number of copies
based on number of items on that paticular invoice.

e.x. 1 item = 1 Copy
5 items = 5 Copies.

even in print preview I see same problem.

 

[Allen Browne]

In Northwind, open the Invoice report in design view.
Open the Sorting And Grouping box (View menu).
Select the OrderId field (first one) in this dialog.
In the lower pane, you see the Group Header and Group Footer are Yes.
So, the report has an OrderId Header.
It prints once only for all the items in the OrderID.
Likewise, the OrderId Footer prints once only after all the items in the
order.

The Detail section prints once for every record in the source.
To see the multiple records, you can open the Invoice query directly.

Use group headers and footers to create what you need.

 

[ILIR ISTREFI]

Dear, Allen

I tried to adjust group headers but unfortunatley i stil face same problems
could it be annything else that is causing this problem.
I changed all the values one by one to see if anything is causing the
problem but the result is same.

Can u please help me on this issue

Ilir,

 

[Allen Browne]

Using grouping will be by far the simplest solution.

It is worth persisting with until you get it.