Hello All, I have constructed the SQL and got all the result but I am not sure how to manipulate these data ? is there any recorder set kind of thing.
>From my 1st SQL, I am getting entire data with 3 types of amountType (PROMOTION_ADJUSTMENT, SALES_TAX & SHIPPING_CHARGES). Now I need to add 2 columns when amountyType = SHIPPING_CHARGES and I need to add 2 rows when amountType = SALES_TAX I really appreciate your help. Thank you. Su- -- View this message in context: http://www.nabble.com/Data-Manipulation-tp25652390p25652390.html Sent from the OFBiz - User mailing list archive at Nabble.com.
