Solved

Duplex report printing on 'even' pages?

Posted on 2008-10-18
3
373 Views
Last Modified: 2013-11-15
Hi,

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?

Regards

Ken
0
Comment
Question by:kenuk110
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22752278
WHere do you have the code?  Which sections?

mlmcc
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 22752280
Have you tried using the NEW PAGE AFTER feature in the section expert with the same code?

mlmcc
0
 

Author Closing Comment

by:kenuk110
ID: 31507527
Thanks for this. Much appreciated.


0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now