Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Address on even numbered paged Post Reply Post New Topic
Author Message
LaurenNY
Newbie
Newbie
Avatar

Joined: 15 Feb 2013
Online Status: Offline
Posts: 10
Quote LaurenNY Replybullet Topic: Address on even numbered paged
    Posted: 15 Feb 2013 at 7:29am
Here is the use case I'm trying to solve:
We have an invoice report that contains the invoice details on page 1 and then on page 2 we print the mailing and return addresses.  This report is printed on a duplex printer (on special paper) that also folds and seals each one so they can be mailed.

What we have now works perfectly for the majority of customers where the invoice details print on 1 page.  However, there are a few customers that have enough data that causes it to print on 2 pages, which messes up the duplex printing and mailers: page 1 = page 1 of invoice, page 2 = page 2 of invoice, page 3 = mailing info

I want to design the report in such a way, where all even numbered pages contain the mailing and return addresses and the odd numbered pages contain the invoice details.  End results are that any customer that has more than 1 page of data, will get more than 1 mailing printed correctly: page 1 = page 1 of invoice, page 2 = mailing info, page 3 = page 2 of invoice, page 4 = mailing info, etc.

I have been playing around with different things but can't come up with a solution that works 100%.

Here is what I have
RH - suppressed
PHa - suppressed PageNumber Mod 2 = 0 (prints on odd pages)
PHb - suppressed PageNumber Mod 2 > 0 (prints on even pages has mailing and return addresses)
GH1 - customer info
GH2 - item info
GH3 - item notes (could be multiple per item)
Details - suppressed
GF3 - suppressed
GF2 - suppressed
GF1 - totals
PF - suppressed
RF - suppressed

I need to take into consideration that the page break may occur any where, all groups have the "Keep Together" checked.

What I have works to some degree, except I cannot get just PHb to print on even pages, it always prints the next thing from the invoice.  I attempted to make the PHb section the same height as my paper minus margins, but get an error when running the report.

Any suggestions?

Thanks

Edited to add some more details


Edited by LaurenNY - 18 Feb 2013 at 8:30am
IP IP Logged
LaurenNY
Newbie
Newbie
Avatar

Joined: 15 Feb 2013
Online Status: Offline
Posts: 10
Quote LaurenNY Replybullet Posted: 18 Feb 2013 at 8:31am
Does anyone have any suggestions?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Feb 2013 at 4:33am

Try turning on "New Page After" for the PHb section.

 
-Dell
IP IP Logged
LaurenNY
Newbie
Newbie
Avatar

Joined: 15 Feb 2013
Online Status: Offline
Posts: 10
Quote LaurenNY Replybullet Posted: 19 Feb 2013 at 5:08am
Originally posted by hilfy

Try turning on "New Page After" for the PHb section.

 
-Dell


I thought of that already, but unfortunately, the "New Page After" is greyed out in the page header sections.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Feb 2013 at 7:14am
Create a top - level GH1 Header where you'll put the address instead of a page header.  Make sure that "Repeat group header on every page" is turned on.  You can then suppress the other group header sections as needed.
 
-Dell
IP IP Logged
LaurenNY
Newbie
Newbie
Avatar

Joined: 15 Feb 2013
Online Status: Offline
Posts: 10
Quote LaurenNY Replybullet Posted: 19 Feb 2013 at 9:35am
Originally posted by hilfy

Create a top - level GH1 Header where you'll put the address instead of a page header.  Make sure that "Repeat group header on every page" is turned on.  You can then suppress the other group header sections as needed.
 
-Dell


Dell,
Thanks for the suggestion.  When I move the addresses to the GH, I have the same issues that I was having with the PH.  If I make it the same height as the page length, I get an error, if I make it smaller that I get data that should go to the next page.  I tried the "New Page After", but it seems like it is ignoring the fact that it is checked and does not do a page break.

I have come up with a solution, which I'm not that fond of.

RH - suppressed
PH - suppressed PageNumber Mod 2 = 0 (prints on odd pages)
GH1 - customer info
GH2a - item info
GH2b - suppressed PageNumber Mod 2 > 0 (prints on even pages has mailing and return addresses)
GH3a - item notes (could be multiple per item)
GH3b - suppressed PageNumber Mod 2 > 0 (prints on even pages has mailing and return addresses)
Details - suppressed
GF3 - suppressed
GF2 - suppressed
GF1a - totals (suppressed page > 1)
GF1b - suppressed PageNumber Mod 2 > 0 (prints on even pages has mailing and return addresses)
GF1c - totals (suppressed if page = 1)
PF - suppressed
RF - suppressed

There are some new page afters checked and reset page number is checked as well.

This seems to be working for the most part.  The only issue I'm having is the underlay following sections does not seem to work on the 2nd page of the invoice (page 3).
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Feb 2013 at 3:59pm
The problem with "Suppress" is that you will "lose" any data that's suppressed.  If you'll run a copy of the report, turn on Save Data with Report, save it and send it to me (I'll pm you my email address) I'll take a look at it and see what I can do.
 
-Dell
IP IP Logged
LaurenNY
Newbie
Newbie
Avatar

Joined: 15 Feb 2013
Online Status: Offline
Posts: 10
Quote LaurenNY Replybullet Posted: 20 Feb 2013 at 2:06am
Originally posted by hilfy

The problem with "Suppress" is that you will "lose" any data that's suppressed.  If you'll run a copy of the report, turn on Save Data with Report, save it and send it to me (I'll pm you my email address) I'll take a look at it and see what I can do.
 
-Dell


Yes, I realized the problem with "Suppress" that is why I have that section twice.
GF1a - totals (suppressed page > 1)
GF1b - suppressed PageNumber Mod 2 > 0 (prints on even pages has mailing and return addresses)
GF1c - totals (suppressed if page = 1)

Thanks for the offer to look at the report, but I am not allowed to share the data with anyone.
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.023 seconds.