Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.
COURSE of the MONTH
15 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Print duplex group data
Posted on 2013-11-06
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.
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.
[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
Active today
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
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
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.
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.
Active today
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
You can use the NEW PAGE AFTER idea on the GF1. Generate it when the page number is odd
PageNumber MOD 2 = 1
mlmcc
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.
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.
Active today
>>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
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
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.
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.
Active today
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
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
Featured Post
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month15 days, 2 hours left to enroll
771 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.