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 100

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.
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need help with software deployments 3 89
Software for Local History Museum Library 5 90
How Parameters Work 2 32
Running reports to the last page automatically 6 28
If your app took Google’s lash recently, here are the 5 most likely reasons.
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…
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.

739 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