I have a report that is grouped by STORE then VENDOR. The report I print is printed in duplex mode on our printer.
When the VENDOR changes within the STORE the report will look to see if the page the last record o a VENDOR appears on is an odd/even page. If it's an odd page then is pretty much puts in an extra blank page. If it's an even page the next vendor will print on the next physical page and all is well.
I got help from experts-exchange to do this. I also need this to happen for the STORE. I have put the following code in the "Section Expert - Suppress (No Drill-Down)" pencil icon but it's not performing the same result.
PageNumber Mod 2 = 1
The end of a STORE will end up on the odd page and the next STORE will end up on the even page.
Any ideas on how to solve this?