Hi all,
Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports.
Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout.
I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.
Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports.
Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout.
I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.
I Added this in expression: =Globals!PageNumber & "/" & Globals!TotalPages.
As you can see, these "constants" can be found under "Globals" in your Expression-window.
Then I saved the layout and try to execute the report in Role Tailored Client.
yes we have achieved the page number is the desired format.
Thanks & Regards,
Saurav Dhyani
www.sauravdhyani.com
And now try to print two copies of this purchase invoice.
ReplyDelete@ anonymus - for printing two copies, i agree that this will not work it will require a group number variable. If you want that i can post the same too.
ReplyDeleteIn my solution I used the original GroupPageNumber function and inserted a new GroupTotalPageNumber function and it worked. If you have a simpler solution, let me know.
ReplyDelete@anonymus - yes that is right, and thank you for sharing the same.
ReplyDeleteYou're welcome. This is a major issue, that ever was a problem in classic NAV. And now it can be solved.
ReplyDeletePlease can you share the code of the new function.
ReplyDeleteThank you
what do you want to pay for??? no, i'm just kidding.
ReplyDeleteHere it is:
REM Reset Page Number:
Shared offset as Integer
Shared newPage as Object
Shared currentgroup1 as Object
Shared currentgroup2 as Object
Shared currentgroup3 as Object
Shared NoOfLoops as integer
Public Function GetGroupPageNumber(NewPage as Boolean, pagenumber as Integer) as Object
If NewPage
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function
Public Function GetGroupTotalPageNumber(NoOfLoopsReportItem as integer, Totalpagenumber as Integer) as Object
If NoOfLoopsReportItem <> 0
NoOfLoops = NoOfLoopsReportItem
End If
Return Totalpagenumber / NoOfLoops
End Function
Really Thank you.
DeleteIf Possible please post comments with your name.
Thanks & regards,
Saurav Dhyani
Ok, how about using this report to print more than 1 invoice document and still being able to display Page X of Y for each of the documents?
DeleteThats a good point. I think the easiest solution is to run the report for each invoice(or any other Document) separately.
Deleteyou're welcome.
ReplyDeletehi sir
ReplyDeletei want know about grouping in Report Navision 2013.
Hi Ganesh,
DeleteWhat exactly is the query. What u want to know abt grouping.
The grouping concept is same that of NAV 2009 SP1 or 2009 R2.
Regards,
Saurav Dhyani