Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : 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: 3702
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
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
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
  

  

    

  
  
 







 

  
   

    

     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

 






                    		
                

            

        		
    

    

        
            HOME | FREE EBOOK |
            PROGRAMMING GUIDE |
            PURCHASE |
            REVIEWS |
            CONTACT ME |
            FAQ |
            LINKS |
            PRIVACY |
            CLICK PLAYS |
            KONACAD 


            
© 2004-2026 Brian Bischof. All Rights Reserved.