I have an invoice report which is grouped by client. I wish to preview the invoices with the invoice numbers AutoNumbers generated at Group Header level in the Invoice table. The problem is that the code in the format part of the group header is executed a number of times, i.e. the first client is shown only after the code for the 2nd client is done and the 2nd client is shown after on clicks on the "next page" arrow and its code gets executed a 2nd time, at which stage the invoice number has gone up by 2. I can get round this by only executing the code when the client changes but there is another complication.
When I actually print the report, it must go through the code again because the invoice number is incremented again for each of the clients. The only solution I can think of is to forget giving a preview at all and just allow the clients to be printed.
Can anyone think of a way to allow the previewing, as well as the printing without updating a varying number of times?
When I actually print the report, it must go through the code again because the invoice number is incremented again for each of the clients. The only solution I can think of is to forget giving a preview at all and just allow the clients to be printed.
Can anyone think of a way to allow the previewing, as well as the printing without updating a varying number of times?
