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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 101

Expert Comment

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

is it a specific group?

LVL 35

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.
Myth Busting: MongoDB Scalability (it scales!)

I was talking with one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. He mentioned to me that several customers have been telling him that “MongoDB doesn’t scale!” MongoDB’s scalability was in question?

My response was, “Is that a joke?"

LVL 101

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 101

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
This article was originally published on Monitis Blog, you can check it here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sourc…
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

623 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