ok, I tried to use href to link to the invoice page but got an issue.
<column source="BookingOrderItemID" caption="Order Item ID" externalsourcename="#transform: ecommerce.orderitem.OrderItemOrderID" parameters="OrderItemOrderID" href="~/CMSModules/Ecommerce/CMSPages/GetInvoice.aspx?orderid={0}" ></column>
I need the parameter to be the orderID, but since the class does not have this field (only orderitemID field) I got the message:
Message: OrderItemOrderID is neither a DataColumn nor a DataRelation for table Table.
I can use the transform in externalsourcename to reference this field though. How can I make the parameter to be the same as the externalsourcename?