Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Navision Report Writer
CHAMBERS
Member Posts: 6
Hello,
Need to create a report with the following data item hierarchy.
Customer
Item Category
Item
The problem is that there is no relationship between the Customer and Item Category, I thought that the answer would be to create a record variable for customer and then Customer.Get and then use the value within customer to filter on table. The problem I have is that it doesn't seem possible without using data items just to say get first record and then the next until last record ?? from the customer table.
Any help / advice
would be appreciated.
Need to create a report with the following data item hierarchy.
Customer
Item Category
Item
The problem is that there is no relationship between the Customer and Item Category, I thought that the answer would be to create a record variable for customer and then Customer.Get and then use the value within customer to filter on table. The problem I have is that it doesn't seem possible without using data items just to say get first record and then the next until last record ?? from the customer table.
Any help / advice
would be appreciated. 0
Comments
What is it exactly you want to accomplish? Is it report showing customers purchase history sorted by item category and number?
If so, take a look at report #10048 Customer/Item Statistics!
Have a great day
Ole
RIS Plus, LLC
MVP - Business Apps