Grouping Under grouping(i.e. - Subgrouping)

anand_sri12
Member Posts: 71
While designing a report i am facing a problem.
I have taken a table -- shipping agent and then Sales invoice header
which is indented under shipping agent
so it looks like
shipping agent
sales invoice header
Now after linking the tables i had sorted the sales invoice header with the key combination (Bill-to City) and grouped the sales invoice header with the same key i.e. - Bill-to City
Coz i wanted to sort the record so that i can get city wise - shipping agent record, which are associated with the sales invoice and then for this particular city i want the total based on bilty no.
ex. REPORT AFTER GROUPING WITH ONLY BILL TO CITY
transporter XYZ
city ABC
bilty quantity
123 54
123 65
123 46
city DGQ
bilty quantity
549 54
549 65
126 46
I WANT MY REPORT TO LOOK LIKE
transporter XYZ
city ABC
bilty quantity
123 165
city DGQ
bilty quantity
549 119
126 46
IT MEANS I WANT A SUB GROUPING HOW TO DO IT????????
I have taken a table -- shipping agent and then Sales invoice header
which is indented under shipping agent
so it looks like
shipping agent
sales invoice header
Now after linking the tables i had sorted the sales invoice header with the key combination (Bill-to City) and grouped the sales invoice header with the same key i.e. - Bill-to City
Coz i wanted to sort the record so that i can get city wise - shipping agent record, which are associated with the sales invoice and then for this particular city i want the total based on bilty no.
ex. REPORT AFTER GROUPING WITH ONLY BILL TO CITY
transporter XYZ
city ABC
bilty quantity
123 54
123 65
123 46
city DGQ
bilty quantity
549 54
549 65
126 46
I WANT MY REPORT TO LOOK LIKE
transporter XYZ
city ABC
bilty quantity
123 165
city DGQ
bilty quantity
549 119
126 46
IT MEANS I WANT A SUB GROUPING HOW TO DO IT????????
With thanks
Anand Kumar
Navision Technical Consultant
Anand Kumar
Navision Technical Consultant
0
Comments
-
It means you need to group it by "Bill-to City, Bilty No." - you need to use key like this and you need to set GroupTotalFields property to same thing (to include both fields in correct order).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
- 321 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