Printing two copies of a report

[cal]

I think I may have gone momentarily ("moment" refers to a somewhat indeterminate period of time) dense.____Version 9.0 build 9.0.009____I want to print a report, calling RRWRUN from a Clipper app and print two copies of the report. BUT, I want it to be printed page 1, 2, 3,... page N and then pages 1-N, again for the second copy, as opposed to page 1, page 1, page 2, page 2, page 3, page 3...____My client says the report used to come out this way. I^ved tried the "collate" check box on the print dialog box the report designer, but the report comes out 1,1,2,2,3,3,... no mater whether the box is checked or unchecked.____Would someone help by leading me out of the darkness, please?____Thanks.____cal

[Robert_Seidman]

Create a variable called copy - copy().____Place this in the header of your report. Now when you tell it to print multiple copies it will collate it for you. In addition, this allows you to put different messages on different copies of the report.____For example, the first copy could say "Office Copy" and the next coulc say "Warehouse Copy".____This would be done by creating a variable - IIF(copy()=1,^Office Copy^, ^Warehouse Copy^,^^)

[cal]

Thanks. That^s a good idea for designating the copies...later.____Now, though, my problem is the order in which the pages come out of the printer. I want page 1 thru N to come out for the first copy, then 1 thru N to come out for the second copy. What I^m getting is 1, 1, 2, 2, 3, 3, ..., n, n.____

[kfleming]

Having the COPY() field on the report will likely correct the collation problem. I think that it why it was suggested.____Kathleen__R&R Support

[Randall_Warden_(Guest)]

Make sure that you sort by the Copy() field.

[cal]

Okay! Now I see how copy() can be used to do this. I did not make the mental leap required to do the sort step. Thanks to the three of you for helping. I did finally realize, too that I could call my PrtRpt() function twice and get the desired result.____I still wonder what the "collate" check box does in the print dialog "File -> Print..., then the "Number of copies" panel. The setting is stored with the report. Even the cute little diagram of the pages changes when the box is checked. BUT... no matter which way it^s set, the result is the same. It^s like "Switch is OFF, I^m in the dark. Switch is ON, I^m still in the dark." Is this the way it should work?____Again, thanks.__Cal

[kfleming]

R&R sometimes ignores the collate checkbox when a report does not contain the COPY() function. It is indeed a bug.____Kathleen__R&R Support

[cal]

Thank you Kathleen. It won^t be a problem now that I understand. I^m certain the bug will be fixed in a later release.____Cal

[KenB]

This is also a problem in version 10.0.012