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.
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Report detail 15 51
Veriface disable 2 31
ServiceCenter IR Query Expressions 1 40
Need help with a Crystal Report in my C#.Net application 2 26
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
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.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
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.

839 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