Printing Duplicate reports for Invoices with multiple lines

  • Thread starter Thread starter Lachlan
  • Start date Start date
L

Lachlan

Hi,

I have created an invoice report for my invoice form. The
form contains a summary form and a subform. The report
contains a summary report and subreport. As in the form
the subreport show the line item information.

The information in the report comes from a query that
contains information from both tables that have been
updated by the forms.

Some invoices have 1 line of data, other invoices have
multiple lines of data.

The data of the report is fine, my problem is that when I
have mutliple line items my report will print the same
invoice the same amount of times as the number line items.
For example I have 5 lines of data in my subreport for
Invioce Number 5 from the main report. The report will
print all the lines on the report but prints the invoice 5
times.

Any help would be deaply appreciated.

Thanks

Lachlan
 
Lachlan,

You probably have two main tables you are using perhaps
invoice table and invoice_detail table. Base your main
report on the invoice table so you recieve the invoice
information (invoice number, customer, address etc) only
once. The sub-report can be based on the detail
information and you will recieve as many records as are
relevent to the invoice. The subreport / main report link
field would be "invoice number" (if I am guessing your
table structure correctly).

This way you will get the invoice stuff once along with as
many details as exist for the invoice.

HTH

Terry
 
Back
Top