11-13-2009 10:24 AM
Hi Experts,
We hav a requirement to do subtotals of the price field for each unique PO Line item, and also to sum up the subtotal values ie. only the subtotal values needs to be added irrespective of the repetation of the po line items in the report.
PO Number PO Item Price
XXXXXXXX 10 20
XXXXXXXX 10 20
Subtotalled 20
YYYYYYY 10 10
YYYYYYY 10 10
Subtotal showing 10
We want the total of price to be 30 ie (Subtotal value of XXXX, 10 = 20 and YYYYY,10 = 10 ) but currently do_sum is been used in the fieldcat of the report which displays all the occurances of the record... = 60(202010+10)
Kindly help asap.
Thanks,
Rosy
11-13-2009 10:27 AM
Hi Rosy,
I dont think this is acheivable without writing your own code for subotalling anf totalling.
regards,
nilesh.
11-14-2009 9:28 AM
Hello,
Use Control Break Statemens in your code.
Then only it is possible to make Subtotals & Totals.
Anil.
11-14-2009 11:12 AM
11-14-2009 11:54 AM
11-14-2009 2:04 PM
Hi rosy,
the question pops up to why you have duplicates in the display table. If you
DELETE ADJACENT DUPLICATES FROM
the output table, everything should be fine.
Regards,
Clemens