Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Sorting report by order type and order no. in NAV 2009 R2.
ManiNav
Member Posts: 120
Hi Everyone,
I have one report that has 2 dataitem: sales header & sales line. Inside report user need to add column 'order type'(Order channel) that is present in customer table, so i have created variable and assigned in sales line on after trigger.
For sorting with order type(Option data-type: B2B, B2C, B2D), i have added customer table as parent data item and sort by order type, after adding order type as secondary key in customer table. Data is got sorted by 'Order type' but order no is not sorting. its sorting with sell to customer no.
e.g.
Screenshot:1.
Screenshot:2.
Screenshot:3.
Screenshot:4.
Report preview:
Please guide me how can i sort with order type then order no. Where i am doing mistake.
Regards,
Mani.
I have one report that has 2 dataitem: sales header & sales line. Inside report user need to add column 'order type'(Order channel) that is present in customer table, so i have created variable and assigned in sales line on after trigger.
For sorting with order type(Option data-type: B2B, B2C, B2D), i have added customer table as parent data item and sort by order type, after adding order type as secondary key in customer table. Data is got sorted by 'Order type' but order no is not sorting. its sorting with sell to customer no.
e.g.
Screenshot:1.
Screenshot:2.
Screenshot:3.
Screenshot:4.
Report preview:
Please guide me how can i sort with order type then order no. Where i am doing mistake.
Regards,
Mani.
0
Comments
As i mentioned for sorting with 'order type'(Customer's field) added customer as parent data-item, but facing issue sorting with 'order no.'. So, i removed customer and for the 'order type' created one new field in sales header as flow field, after that in header created another field that has copy of flowfield to assign as secondary key for sorting. But, how the data will come from flowfield to normal field(Copy of flowfield that another newly created in header).
Please guide me to resolve the above barrier for the solution.
Thanks,
Mani.