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.
Course Of The Month
1 day, 21 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
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:
…
Suggested Courses
Course of the Month1 day, 21 hours left to enroll
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.