2014年12月11日 星期四

generator-sumtotal generator-total

generator-subtotal generator-sum

Sum 1 column Grand Total

{SumTotal}SumTotal('tableName()','this.id','this.id','query.DOMAIN_AMOUNT','query.DOMAIN_AMOUNT'){/SumTotal}


Sum Qty, price to amount and Grand Total

{SumTotal}SumTotal('tableName()','this..QTY','this..PRICE','this..AMOUNT','SUPPLIER_INVOICE_HEADER.AMOUNT',
1,'SUPPLIER_INVOICE_LINE',''){/SumTotal}

***********************************************

1.261,SALES_ORDER_INV_DESC.PRICE,text:GRID,10%,150,Price,,{numeric} {alignRight} {SumTotal}SumTotal('tableName()','this..QTY','this.id','this..AMOUNT'){/SumTotal}

Red Color Must 

沒有留言:

張貼留言