how can i do a total amount using GroupTotalFields property
gorvega79
Member Posts: 73
how i can totalizate an amount in a report for a simple data item
0
Answers
-
The GroupTotalFields property determines which fields to group the data on. For totaling you would use the TotalFields property. Let's say you want to total an Amount field from the customer Ledger Entry table, and you want to see a total per customer. You would define Amount in TotalFields, and Customer number in GroupTotalFields. All you need to do now is to place the Amount field in a groupfooter section, and in a footer section for a total for the dataitem, and the report should automatically display the total values for you. No code necessary.1
-
-
You're so welcome, always glad to be able to help. Did you get your report to total?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
- 320 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