Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Duplex report printing on 'even' pages?

Posted on 2008-10-18
3
Medium Priority
?
380 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 101

Expert Comment

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

mlmcc
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

722 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