Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I display page numbers on drill down pages 1

Status
Not open for further replies.

jcl5

IS-IT--Management
Dec 6, 2002
89
GB
Using Crystal 10, Oracle database:-

I have a report grouped and totalled by area code. I have the business details as a drill-down on the detail line and want to show the page number, reset per area on the drill down pages.

Can anyone help?

Thanks

jcl5
 
Would you settle for the page number placed on the page header of the report?

if yes then all you need is
two formula using whileprintingrecords function

1 @PageN

whileprintingrecords;
numbervar MyPage:=MyPage + 1

Place this one on The Page Header

2 @ResetPage

whileprintingrecords;
numbervar MyPage:=0

place this one at the footer of the group you want to use to restart the count.

you have an option to make the second field invisible.

I’m sure that you can achieve the results you want with running totals as well.


Mo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top