Crystal Reports 2008 Pages

Posted on 2014-04-22
Last Modified: 2014-04-23
I have a report that has multiple pages but need to have certain sections get numbered.  For example I have one that now has 6 pages - but only want to show page numbers starting on page 2 and then for the number of pages in this section of the report and then to start again with page 1when it gets to the second to the last page so that the last two pages would be 1 and 2 again.  I could actually hard code the last 2 pages I suppose but the pages that could print after page 2 could vary.  Is something like this possible is Crystal?
Question by:jajen
  • 3
  • 3
LVL 100

Expert Comment

ID: 40014757
WHen you say sections, can you identify when that section is being printed?

is it a specific group?

LVL 34

Expert Comment

ID: 40017096
In addition to mlmcc's questions, when you say that you want to see page numbers starting on page 2, how should they be numbered?  Do you want to see 2 on page 2 (so the page numbers haven't changed, and you're just not showing the page number on the first page), or should page 2 be labeled as page 1 (and page 3 as 2, and so on) ?


Author Comment

ID: 40017346
The way the report is setup the first page is more of the welcome letter so they want page 2 to show as page 1 and then the pages that are generated by this formula to show as say 2 of 3 and then 3 of 3.  I know the best way would probably be to create sub-report but doing this would create another issue.  So I just wanted to see if anyone knew of a way to do page numbering possibly on data generated from a particular detail section.
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

LVL 100

Expert Comment

ID: 40017357
Still need to understand the setup of the report.

Are there groups

Is the report header used to generate that first page?


Author Comment

ID: 40017727
Yes there is a report header that is suppressed, a page header that has what is needed to show on all pages - tried the special field Page N of M which of course started with first page and number all others.  The rest of info is in detail sections ranging from Detail A thru O.  There is also a sub report in one of the detail sections. If there is someway to number pages based on the detail sections of the report- The main report currently does not have any groups just the sub report.
LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 40017747
The solution is going to be a bit complex so let's try to solve it in small parts.

I assume one or more of the detail sections comprise the page 1 letter.
Right click the left margin of the last one of these
Click the PAGING tab on the right
Click OK

DO you see the reset of the page numbers

Are there other pages you don't want the pages numbering on?


Author Comment

ID: 40017818
Yes this is working to do what I want.  I was able to use this to also fix the other pages that needed numbers. Thank you for being patient and working with me on this!

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Driver Problem 12 82
Clipboard Manager for Windows 7 5 54
Date is within the current week in Crystal Reports 2 46
How to open a .vcf file 11 49
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now