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

0
Comments
-
Hello there,
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
Ole0 -
There is no link between Customer and Item Category, so this hierarchy will not work.0
-
True Daniel, but it's pretty easy to set up0
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