Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Printing double sided with page breaks.... help !! Post Reply Post New Topic
Author Message
Seabass
Newbie
Newbie
Avatar

Joined: 06 Jun 2009
Location: United States
Online Status: Offline
Posts: 32
Quote Seabass Replybullet Topic: Printing double sided with page breaks.... help !!
    Posted: 11 Aug 2009 at 5:19am
Good morning Folks,
 
I created a report, where my parameters allows me to enter multiple value that query a database. Each entry is called a work order. Some of them are 2 pages (fit on one page) some others are 3 pages (that's where my issues are...)
 
The requirement is that i need to have each work order printout in a separate package. Therefore, when i have one that has an odd number of pages, i get the page break and the next record (work order) print on the back of let's say page 3.....Cry Right now, i am printing one work order at a time and it is quite time consuming...
 
Is there a way to get this to reset to the next page ???
 
I am using Crystal XI and it will be published in Business Object.... 
 
Any help will be truly appreciated...
 
Seabass 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Aug 2009 at 6:12am
Let's see if I have this correctly...each work order must be on its own sheet(s) of paper, no overlap.  Sounds reasonable.
 
If this is the case, what I would suggest is a shared variable that is a page counter.  I am guessing that there is a group for each work order, and there is a new page before, at least I would have the report set up that way.  What I would do is add another section to the group, and then move it before the 'real' section so you have something like
GH1a (empty)
GH1b (the original header)
 
Go to section expert and add a conditional to the new page before, something like:
shared numbervar pageNo;
not onFirstRecord
and
pageNo mod 2 = 1  //it might need to be zero or an 'OR'
 
in the page header you would need
shared numbervar pageNo := pageNo + 1;
""  //hides the incementing
 
Hopefully this helps...it should at least give a path to travel.
IP IP Logged
Seabass
Newbie
Newbie
Avatar

Joined: 06 Jun 2009
Location: United States
Online Status: Offline
Posts: 32
Quote Seabass Replybullet Posted: 11 Aug 2009 at 8:06am
thanks for the quick response.... I still need a little assistance, sorry i am new to this stuff....
 
I got the first part all set in the conditional format as you explained....
 
shared numbervar pageNo;
not onFirstRecord
and
pageNo mod 2 = 0  //it might need to be zero or an 'OR'
 
What is the difference between 0 and 1 ???
 
Also, whee in the page header do i put the next section ?  you mentioned in the page header... but i am not sure where... and what is the "" //hide the incementing really means??? sorry just need a few clarificaitons....
 
 
in the page header you would need
shared numbervar pageNo := pageNo + 1;
""  //hides the incementing
 
Thanks !
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Aug 2009 at 8:35am
FYI...Other post to refer to if desired
 


Edited by DBlank - 11 Aug 2009 at 8:39am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Aug 2009 at 12:08pm
let's start with the easy stuff first,
"" //hides...
 
Crystal will print the last value that a formula uses.  By doing this, you can drop the formula anywhere and it will not display on the report.  The person who taught me, would make the formula small and change the font to match the background, so it was hard to find if you needed to change something.  This is much simpler.
 
1 or 0 in a mod function.  mod returns the remainder from division problem, so 5 mod 2 is 1...5/2=2 remainder 1.  0 in this case stands for even numbers and 1 is for odd.  You always want to make your page count even, so that a new work order starts on a new piece of paper.
 
The formula can be dropped anywhere on the page header as it will be executed when the page is drawn, and is for all intents and purposes invisible.
 
Hope this helps
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.000 seconds.