Multiple Copies

[Robert_Seidman]

Dear Kathleen:____A problem for which I would greatly appreciate your help.____I would like to print 2 copies of an invoice. On the first copy I would like to say "Original", on the 2nd copy I would like to say"Duplicate".____To do this, I have created a variable called "Copies".____The expression is simply the function "copy()"____I then created another calculated expression "copymesage":____IIF(copies=1,^Original^,Duplicate)____This works great and has the desired effect. The problem is when I go to print the entire batch.____I want to print the first invoice that says "Original" and then the copy of the first invoice that says "Duplicate". I then want to print both copies of the 2nd invoice, etc, etc.____My problem is that, whether or not I have collate checked in the printer properties, as long as I have the "copymessage" field on my report, the reports prints all of the invoices with the "Original" message, and then prints all of the invoices with "Duplicate" message.____As soon as I remove the "copymessage" field from the report, it reverts to printing 2 copies of the first invoice, then 2 copies of the 2nd invoice etc. as it should.____Any suggestions for overcoming this problem____I thank you in advance__RHS____

[kfleming]

Make the field copies a group field in the report. Collation can behave incorrectly unless a COPY() field is used in the report.____Kathleen__R&R Support

[Robert_Seidman]

Dear Kathleen:____Are you saying that I should put the calculated field "copies" into the group header instead of putting it in the page header?____I have done that (I have also tried putting in the page footer), and it does not seem to make any difference.____Thanks again.____RHS__

[kfleming]

Make the calculated field copies a group field in the report and see if it helps.____Kathleen__R&R Support

[Robert_Seidman]

Thanks again for your response, but I have put the field in the group header with no change. I get the same result. I have also tried putting the field in the page footer, and again get the same result.____I am baffled.____RHS

[kfleming]

Did you go to Database Group Order and then as your last group field select the field copies? That might help.____Kathleen__R&R Support

[Robert_Seidman]

That did not seem to make any difference, but I thank you anyway for your time and attention to this matter.____RHS