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.
Please guide me how can i sort with order type then order no. Where i am doing mistake.