Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Duplicate Pages Issue Post Reply Post New Topic
Author Message
twisternhra
Newbie
Newbie


Joined: 06 Jun 2012
Online Status: Offline
Posts: 4
Quote twisternhra Replybullet Topic: Duplicate Pages Issue
     Posted: 06 Jun 2012 at 9:48am
I have a report with several checks and each check has invoices attached. I am trying to make print each check twice.

Here is how everything is setup.
I have a group for the invoices with 2 detail sections. The first one has a formula to insert a page after the current invoice if the next invoice is part of a different check.
(Next({checkhed.Calc_DspCheckNum}) <> {checkhed.Calc_DspCheckNum})
The second detail section just has a subreport that is only shown on even pages.

The problem that I am having is that the last check isn't being duplicated. It seems like the formula isn't running for the last invoice.

Anyone have any idea whats going on?                     
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Jun 2012 at 10:29am
in the fomrula editor try changing the option about how to handle nulls to 'default values for nulls'
IP IP Logged
twisternhra
Newbie
Newbie


Joined: 06 Jun 2012
Online Status: Offline
Posts: 4
Quote twisternhra Replybullet Posted: 06 Jun 2012 at 11:03am
Well that fixed part of the problem.   The formula is now working and returning true but am still not getting a duplicated page.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Jun 2012 at 11:11am

do you mean that there is no detail B (with a subreport) running on the last page which is an even numbered page?



Edited by DBlank - 06 Jun 2012 at 11:11am
IP IP Logged
twisternhra
Newbie
Newbie


Joined: 06 Jun 2012
Online Status: Offline
Posts: 4
Quote twisternhra Replybullet Posted: 06 Jun 2012 at 11:22am
The last page that I get is page 21 which has detail A that has the formula to insert a new page. (Detail A is shown on odd numbered pages)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Jun 2012 at 11:25am
try adding
onlastrecord or (Next({checkhed.Calc_DspCheckNum}) <> {checkhed.Calc_DspCheckNum})
 
for the new page formula


Edited by DBlank - 06 Jun 2012 at 11:25am
IP IP Logged
twisternhra
Newbie
Newbie


Joined: 06 Jun 2012
Online Status: Offline
Posts: 4
Quote twisternhra Replybullet Posted: 20 Jun 2012 at 3:31am
That isn't working either. I have a field showing the result of the formula and on the last record of the last page it shows true, so I have no clue why a new page isn't being created.
IP IP Logged
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