Hi
I have a case where I have a table with orders that contains fields for order numbers and parent id numbers. Now I want to be able to drill down from main order to child order in a report. The problem is the only difference between a main and a child order is the parent id is empty for main order and filled in with order of main order number on child order.
So what I want to achieve is a list of main orders and when clicking one order I want to see child orders.
I'm quite new at BO so please excuse my stupid question...
Server version is 3.1 and DW is SQL.
Thanks for your help!
Regards,
Magnus