Show Total Page In Report
 
            
                
                    jerry09                
                
                    Member Posts: 3                
            
                        
            
                    hi all, i'm using Dynamic Nav 5.0 Sp1, i want to show my total page in my report, anybody have idea how to calculate total page in report? thanks for help me ^^                
                0                
            Comments
- 
            You should add a new footer section: select report DataItem, View -> Sections, press F3 and select "Footer" section type.
 Create a textbox with the the field you want to totalize and add the same field in the "TotalFields" property of the DataItem.* Daniele Rebussi * | * Rebu NAV Diary *0
- 
            but what i meant is i want to show like 1 of 10, 2 of 10, or 1 of 5, i want to know the corect way to get of 5 or of 10 and show it in my report0
- 
            there is no easy way to show "page n of m" in classic reports. But this is a topic that gets asked a lot and there have been workarounds posted before, so i suggest you use the search.0
- 
            Try like this:
 Eg there is a customer table first count the total no of records
 make a variable totalrecrds:= Customer.Count
 then chech how many records are getting printed on a page
 like there are total 60 records and on one page total records printing at a time are 10
 then divide the total no of records by 10
 if (totalrcrds mod 10 =0) then
 qut:= totlrcrds div 10
 else
 qut:=(totalrcrds div 10) + 1
 and write like this
 page currreport.pageno of qut
 so it will print like this page 1 of 6, page 2 of 6 etc.
 hope it will help you.... 0 0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 323 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions


