I modified from the built-in RDLC 1306 sale invoice report layout, use a SUM in expression to calculate the total of the order line discount value. It work fine on the order I created manually. but showed #Error on order sync from Shopify.
My expression involve 3 value from Dataset. I found for "LineDiscountPercent_Line" the Sum work fine on, but "UnitPrice" & "Quantity_Line" both can not get the Sum work in Shopify order.
Could any one kindly help me locate the Error, and how to fix it.
This is the expression:
Work fine on normal order:
Show error on Shopify order: