Summariser showing related data in group
We are trying to show a table of order lines, and use the group feature to group them by order_id.
Ideally we would be able to show data from the related order, and we would be able to specify a custom view / component
So we would have:
===================
Order header
Order 1 : status
Order 1 : date
----------------------
Orderline 1: quantity
Orderline 1: amount
----------------------
Orderline 2: quantity
Orderline 2: amount
===================
Order header
Order 2 : status
Order 2 : date
----------------------
Orderline 1: quantity
Orderline 1: amount
----------------------
Orderline 2: quantity
Orderline 2: amount
Can this be achieved?
Ideally we would be able to show data from the related order, and we would be able to specify a custom view / component
So we would have:
===================
Order header
Order 1 : status
Order 1 : date
----------------------
Orderline 1: quantity
Orderline 1: amount
----------------------
Orderline 2: quantity
Orderline 2: amount
===================
Order header
Order 2 : status
Order 2 : date
----------------------
Orderline 1: quantity
Orderline 1: amount
----------------------
Orderline 2: quantity
Orderline 2: amount
Can this be achieved?