Navision Report Writer

CHAMBERS

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.

oleschjoeth

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

Ole

DenSter

There is no link between Customer and Item Category, so this hierarchy will not work.

oleschjoeth

True Daniel, but it's pretty easy to set up