New to Autoline but am trying to write some simple reports. First question is how do I 'subtotal' a number of transactions into 1 row.
eg in a POS report I have a single table, 'parts' and have created a derived field TOTCOST being !1_COSTPRCE* !1_ORDERQTY
Format of the report is very simple, just has WIPNO & TOTCOST
When I run the report it brings up several lines for each WIPNO ie a line for each individual part cost - how can I 'subtotal' the parts costs so that the report just has 1 line for each WIPNO ?
I've tried the subtotal check boxes etc but that puts a total at the end of the list which is not what I want
Who is online
Users browsing this forum: No registered users and 2 guests