You can split them up this way:

 

1.  Group by Invoice Number.

2.  Move the objects from the Page Headers and Report Header to Invoice Group Header sections.

3.  On the section where you've place what used to be the report header, set the Suppress formula to something like: {table.Invoice#} = previous({table.Invoice#})  This way it will print only at the beginning of an invoice.  Also set any other section options (like New Page After) that you had set on the original Report Header section.

4.  On the Invoice Group Footer section, do the following:

     a.  Turn on "Reset Page Number After"

     b.  Turn on "New Page After"

     c.   In the New Page After formula put: Not OnLastRecord.  This will prevent a blank page at the end of the report.

 

-Dell

 I have four groups set up.  Group #1 - ARInvoice.InvoiceNo - This has the Logo, Cust Address, Inv. #, date and general invoice information and should only print on the first page of the invoice; Group #2 - ARInvoice.InvoiceNo - needs to print on the subsequent pages after page one.  This has the logo and invoice number; Group #3 - ARInvoice.InvoiceNo - this is the labels and should print on all pages.  Group #4 - @date - this one works fine.  It is grouped by date and prints the date, items associated with that date and prints the subtotal.  I want the total to print on the last page of the invoice with the last record.

 

What is happening - my Group #2 doesn't print until the first page of the second invoice, my group #3 Prints on the first page of each invoice and not on any other pages, my total prints on the last page by itself.  Please help!  Thanks!!!

Client wants to print multiple invoices in a range.  Parameter is set.

 

Group Header #1a - includes company logo, address, invoice number, customer id, etc.  This should appear only on page 1 of each invoice.

 

Group Header #1b - includes company logo and invoice number (should print on all pages of the invoice except the first page.)

 

Group Header #1c - includes column headings such as qty, unit of measure, and description. (should print on all pages of the invoice including the first page).

 

Group Header #2.  It is a date.  All line items of the invoice are grouped by date.  There should be only one date and associated data per page with a subtotal for each date.  The invoice is sorted by this group in ascending date order. The total is on the last page of the invoice.  Not alone but with the last group of data.

 

Of course the detail section includes the description, qty, price, etc.

 

Please help.  I tried the suggestions but have not been able to get this to work.  I did not try a subreport as I would like to try to get the existing report to work if possible.

 

Thanks!