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.
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
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:
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
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:
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