Solved

Print duplex group data

Posted on 2013-11-06
11
390 Views
Last Modified: 2013-11-18
I have a report with several hundred pages.
Report   layout is  something as :
Report Header, Page header, Group1 Header, Detail section then
I divided Group1 footer in several sections as I needed some spacing :
I have several Group footers
Group Footer 1_a ,
Group Footer 1_b,
Group Footer 1_c,
Group Footer 1_d,
Group Footer 1_e.
Then I had Page footer, report footer.

I had page number reset at last sub section of group1 at Group Footer 1_e.

Number of pages for a group depending on data can go from at least 2 to the most  as 5 or 6.
Context of  section of Group Footer1_e I want to be on one side of page.
It is preset empty grid- table that user will use to fill data in and it fit on one page not broken on two pages and that is reason that I put New page before in this section.

Everything was ok up to user decided that it is to much paper for print and wants  to save on paper and print duplex  on both side of paper.
He wants  that first page of group always  has to be on front side of paper never on  back side, does not matter how many pages group has 2,3,4,5,6.
At the same time section of Group Footer1_e has to be on one side of pages not broken on two sides.
I  got suggestion to check in Group Footer1_e New page After and put this in x-2 PageNumber MOD 2 = 1
However in case when  group has 3 pages page# 1 of next group is printed on back side of  page2 instead on front side of next page ,back side of page two has to be empty. The same is as group has 5 pages third page back side has to be empty.
0
Comment
Question by:Taras
[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
  • 6
  • 5
11 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39630150
YOu should be able to check the KEEP TOGETHER option for GF1e

Right click GF1e in the left margin
CLick SECTION EXPERT
Verify GF1e is selected in the section list
CLick KEEP TOGETHER

Does it work as you want?

Is  GF1e the last section of GF1?

mlmcc
0
 

Author Comment

by:Taras
ID: 39630417
Yes GF1e is last section of GF1.
 I need that section to be on one side of page not split between two pages or two sides of one page.
And page after that has next data for G1 and it will be page#1  and  that should  always be on the  front side of page.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39630615
The KEEP TOGETHER on the GF1e should take care of keeping it on 1 page assuming it will fit.

You can use the NEW PAGE AFTER idea on the GF1.  Generate it when the page number is odd

PageNumber MOD 2 = 1

mlmcc
0
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

 

Author Comment

by:Taras
ID: 39631455
I tried this:
KEEP TOGETHER on the GF1e
NEW PAGE AFTER on GF1e x-2 PageNumber MOD 2 = 1  and  still it is not printing properly.
One question should I check box on GF1e  beside x-2 or not?
What would happen if I do not check box just put formula in x-2?

It strange when group has three pages it prints ok, next page (first page of next group)  goes on front side of next page,  but when group G1 have 5 pages it print first page of next group on back of previous group (page#3) what is not ok.

How do you think: “You can use the NEW PAGE AFTER idea on the GF1”  you probably wanted to say on GF1e.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39631518
>>One question should I check box on GF1e  beside x-2 or not?
I don't.  IN some versions there seems to be a difference in how it works with it checked or not checked.  I believe if using a formula you are not supposed to check the box but I have seen nothing formal from SAP/Crystal that says that or that indicates there is a difference in the behavior if it is checked compared to not checked.

>>How do you think: “You can use the NEW PAGE AFTER idea on the GF1”  you probably wanted to say on GF1e.
No I meant GF1.  It should work the same as in GF1e.

In the case of the 5 pages, is the page full?

mlmcc
0
 

Author Comment

by:Taras
ID: 39631619
I do not have GF1.
 I think when you enter new subsection in footer it gives title GF1a, GF1b and on.
Yes page 5 is full and it is seating on back side of physical page#3.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39632094
In the SECTION EXPERT there is still a GF1 section you can use

I think the issue is it prints GF1e then does a NEW PAGE because it is full then when it tests for NEW PAGE AFTER it realizes it already did one but maybe hasn't updated the page number yet

DO you have a page header and footer?
Can you shrink them at all?

mlmcc
0
 

Author Comment

by:Taras
ID: 39632708
I have page header and page footer.
They are shrank  pretty much.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39633281
Can you upload the report file?

mlmcc
0
 

Author Comment

by:Taras
ID: 39633341
No, I can not as data are cnf.
0
 

Author Closing Comment

by:Taras
ID: 39658252
Thanks
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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