Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Multiple Page Numbers Post Reply Post New Topic
Author Message
merkman
Newbie
Newbie


Joined: 19 Mar 2008
Online Status: Offline
Posts: 8
Quote merkman Replybullet Topic: Multiple Page Numbers
    Posted: 20 Mar 2008 at 10:57am

Crystal Reports
Product Version: 11.5.9.1076
OS: Microsoft Windows XP Pro
Database: MS SQL Server 2005
Connection Type: OLE DB (ADO) via UDL

 

 

I have a report that resets the page number after a certain group.

I display N of N pages for that group.

 

I would also like to display N of N pages for the entire document.

 

I am thinking I would have a variable then after each page increment that variable. Does crystal Reports 11 support an "after page event"?

 

Or how would I go about doing this?

 

Thanks



Edited by merkman - 20 Mar 2008 at 11:00am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 20 Mar 2008 at 2:02pm
I don't know if this would work, but you might be able to create a running total that would at least get you the current page number.  Because of the way Crystal processes data, I doubt you'll ever be able to get the total page count.
 
First, create a formula that just contains the number 1.  I'll call it PageCount.
 
Create a Running Total:
Field to Summarize: {@PageCount}
Type of Summary: Sum
Evaluate: Use Formula: pagenumber > previous(pagenumber)
Reset: Never
 
-Dell
IP IP Logged
merkman
Newbie
Newbie


Joined: 19 Mar 2008
Online Status: Offline
Posts: 8
Quote merkman Replybullet Posted: 21 Mar 2008 at 5:20am
I went with the following formula for the entire documents current page number.
I can't think of a way to get the total page count for the entire document either.
 
Global StringVar PreviousGroupParentBy;
Global NumberVar RunningPageCount;
 
IF GroupName ({@GroupParentBy}) <> PreviousGroupParentBy then
    (PreviousGroupParentBy := GroupName ({@GroupParentBy});
     RunningPageCount := RunningPageCount + 1;
     RunningPageCount)
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 21 Mar 2008 at 10:34am
I'm confused. You can't use the TotalPageCount function found under the Print State functions in the Formula Workshop?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
merkman
Newbie
Newbie


Joined: 19 Mar 2008
Online Status: Offline
Posts: 8
Quote merkman Replybullet Posted: 24 Mar 2008 at 10:45am
Originally posted by BrianBischof

I'm confused. You can't use the TotalPageCount function found under the Print State functions in the Formula Workshop?
 
The report that resets the page number after a certain group.
 
So the TotalPageCount is reset also
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.031 seconds.