Skip to Content

How to display page or line number in the footer of a page or details section?

I am using crystal report 2016. In my report, I want to display 1 of 2 or 2 of 2+ and so on. When I run the report, it displays the total number of page. 4 of 100. I dont know which setting causes this to come like this. I want line number to be displayed properly as 1 of 8 and so on. So please help me on this.

Below is a screenshot of my desired result. 1/1 or 1 of 2. I can use / or the word OF.

capture.jpg (37.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 04 at 07:31 AM

    You can create a formula and display page count as you want. You should be able to copy text below as pagenumber and totalpagecount are crystal functions

    @Pagenumber

    Tonumber(pagenumber,0,"")&'/'&Tonumber(totalpagecount,0,"")

    Ian

    Ps if totalpagecount does not go blue check in Crystal help, its something like that I do not have crystal on this PC

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks :)

      I have a set of data in Crystal reports that looks like below: You can see that each item, they have corresponding quantity.

      However, there are no suppressed details in the report then the line-number should be equal to RecordNumber. So the following formula I got is:

      CStr(RecordNumber, "0") & "/" & CStr(Count({rpt_PackingSlip.LabelQTY}), "0")

      which resulted to:

      Notice that it sums all the records which are in total of 11.

      But my desired output is:

  • Apr 04 at 04:45 PM

    You can't get something like "2 of 2+", like Ian outlines, you'll always get the total number of pages. Be aware that this can significantly slow down your report. Normally, when you run a report without using "page n of m" or totalpages, it will show the first page of the report as soon as it is rendered. However, if you use either of those special formulas, Crystal needs to render ALL of the pages before it will show the first one. If you just have a few pages, it's not a big deal, but for 100 pages, it will be noticeably slower. And if you have subreports on any of those pages it will be even slower than that.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded