Skip to Content
0

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

Apr 03 at 11:36 PM

42

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Apr 04 at 07:31 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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:

0
Dell Stinnett-Christy Apr 04 at 04:45 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks Dell. :)

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:

0

Hi Trish,

None of your examples appear on the screen when I view your comment, so I'm having a hard time trying to answer your question.

-Dell

0