I have a bunch of fairly big reports that I have to print. We've recently put in a whole bunch of printers which print duplex (yay!). To save a tree, and save some space in the file drawers and for the reports which we have to mail, we want to duplex as much as possible!
In several of these reports, I reset page numbers after certain sections - everytime there is a sales person change. This is no problem and works great. If I want to duplex this report for printing, I can't have the last page of one person's section end on page 3 and the next person start on page 4, the next person would need to start on page 5. So in the function/calculation for the group footer (where I check insert new page after) is the place I think I need to be looking, where I am getting stuck is what what/how to put here, If the Total Number of pages in this section is odd (TotalPages MOD 2 = 1) then I need to insert two page breaks, if totalPages MOD 2 = 0 then I just need to insert one page break.
Any ideas how to do this?
Mark / TNG
In several of these reports, I reset page numbers after certain sections - everytime there is a sales person change. This is no problem and works great. If I want to duplex this report for printing, I can't have the last page of one person's section end on page 3 and the next person start on page 4, the next person would need to start on page 5. So in the function/calculation for the group footer (where I check insert new page after) is the place I think I need to be looking, where I am getting stuck is what what/how to put here, If the Total Number of pages in this section is odd (TotalPages MOD 2 = 1) then I need to insert two page breaks, if totalPages MOD 2 = 0 then I just need to insert one page break.
Any ideas how to do this?
Mark / TNG