Print Page | Close Window

Multiple Page Numbers

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2664
Printed Date: 28 Apr 2024 at 10:42am


Topic: Multiple Page Numbers
Posted By: merkman
Subject: Multiple Page Numbers
Date 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


Replies:
Posted By: hilfy
Date 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: mailto:%7b@PageCount - {@PageCount }
Type of Summary: Sum
Evaluate: Use Formula: pagenumber > previous(pagenumber)
Reset: Never
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: merkman
Date 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 ( mailto:%7b@GroupParentBy - {@GroupParentBy }) <> PreviousGroupParentBy then
    (PreviousGroupParentBy := GroupName ( mailto:%7b@GroupParentBy - {@GroupParentBy });
     RunningPageCount := RunningPageCount + 1;
     RunningPageCount)

Posted By: BrianBischof
Date 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>

Posted By: merkman
Date 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


Print Page | Close Window