Eclipse BIRT Designer Version 2.5.1.v20090903 Build <2.5.1.v20090917-1447> in /templates/blank_report.gif fixed layout ltr 1 productPromoId string 2 promoName string 3 totalOrders integer 4 totalOrdersAmount float 5 totalShippingAmount float 6 totalShippingCharge float 7 totalShippingBalance float productPromoId promoName totalOrders totalOrdersAmount totalShippingAmount totalShippingCharge totalShippingBalance 1 productPromoId string 2 promoName string 3 totalOrders integer 4 totalOrdersAmount float 5 totalShippingAmount float 6 totalShippingCharge float 7 totalShippingBalance float OFBIZ = totalRow) return false; userLogin = null; input = new HashMap(); try { userLogin = delegator.findOne("UserLogin",UtilMisc.toMap("userLoginId","admin"), false); } catch(e) { Debug.logError(e,""); } couponSalesOrder = couponSalesOrders.get(countOfRow); productPromoId = couponSalesOrder.getString("productPromoId"); promoName = couponSalesOrder.getString("promoName"); //Total Orders, Amount amd Shipping amount = 0 totalOrders = 0; totalOrdersAmount = 0; totalShippingAmount = 0; totalShippingCharge = 0; totalShippingBalance = 0; productPromoCodes = delegator.findList("ProductPromoCode", EntityCondition.makeCondition("productPromoId", EntityOperator.EQUALS, productPromoId), null, null, null, false); if(productPromoCodes.size()>0){ productPromoCodeId = productPromoCodes.get(0).getString("productPromoCodeId"); orderProductPromoCodes = delegator.findList("OrderProductPromoCode", EntityCondition.makeCondition("productPromoCodeId", EntityOperator.EQUALS, productPromoCodeId), null, null, null, false); totalOrders = orderProductPromoCodes.size(); for(i = 0; i < totalOrders; i++){ orderId = orderProductPromoCodes.get(i).getString("orderId"); input.put("userLogin",userLogin); input.put("orderId",orderId); //Order Total orderInfo = dispatcher.runSync("getOrderHeaderInformation", input); amount = orderInfo.get("grandTotal"); totalOrdersAmount = totalOrdersAmount + amount; //Shipping Total cond = new LinkedList(); cond.add(EntityCondition.makeCondition("orderId", EntityOperator.EQUALS, orderId)); cond.add(EntityCondition.makeCondition("orderAdjustmentTypeId", EntityOperator.EQUALS, "SHIPPING_CHARGES")); orderAdjustments = delegator.findList("OrderAdjustment", EntityCondition.makeCondition(cond, EntityOperator.AND), null, null, null, false); orderAdjustmentSize = orderAdjustments.size(); for(j = 0; j < orderAdjustmentSize; j++){ shippingCharge = 0; shippingCharge = orderAdjustments.get(j).get("amount"); if(shippingCharge){ shippingCharge = shippingCharge.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue(); } totalShippingCharge = totalShippingCharge + shippingCharge; } shippingAmount = dispatcher.runSync("getOrderShippingAmount", input); amount = shippingAmount.get("shippingAmount"); if(amount){ amount = amount.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue(); } totalShippingAmount = totalShippingAmount + amount; } } row["productPromoId"] = productPromoId; row["promoName"] = promoName; row["totalOrders"] = totalOrders; row["totalOrdersAmount"] = totalOrdersAmount; row["totalShippingCharge"] = totalShippingCharge; row["totalShippingAmount"] = totalShippingAmount; row["totalShippingBalance"] = totalShippingAmount - totalShippingCharge; countOfRow ++; return true;]]> NewTabularHierarchy string productPromoId string promoName dataSetRow["totalOrders"] integer dataSetRow["totalOrdersAmount"] float dataSetRow["totalShippingCharge"] float dataSetRow["totalShippingAmount"] float dataSetRow["totalShippingBalance"] float CouponSalesReport landscape 0.25in 0.4777777777777778in 0.4777777777777778in html new Date()]]> right 0.2777777777777778in 2.3777777777777778in 1.788888888888889in 0.14444444444444443in 0.4444444444444444in 0.2777777777777778in page-number plain left total-page 16pt bold center auto totalOrders Group/promoName center totalOrders_Group/promoName 0.3333333333333333in 0.5555555555555556in #BFBFBF bold center totalOrders 0.23333333333333334in #BFBFBF bold center Orders #BFBFBF 0.3in Group/promoName Fixed Fixed center totalOrdersPercent 0.45555555555555555in #BFBFBF bold center 100 #BFBFBF bold center % #BFBFBF totalOrdersAmount Group/promoName Fixed #,##0.00 right totalOrdersAmount_Group/promoName 0.7555555555555555in #BFBFBF bold Fixed #,##0.00 right totalOrdersAmount #BFBFBF bold center Orders $ #BFBFBF Group/promoName Fixed Fixed center totalOrdersAmountPercent 0.4222222222222222in #BFBFBF bold center 100 #BFBFBF bold center % #BFBFBF totalShippingCharge Group/promoName right totalShippingCharge_Group/promoName 1.6in #BFBFBF bold right totalShippingCharge #BFBFBF bold center Ship from Customer $ #BFBFBF totalShippingAmount Group/promoName right totalShippingAmount_Group/promoName 1.6555555555555554in #BFBFBF bold right totalShippingAmount #BFBFBF bold center Ship to Wherehouse $ #BFBFBF totalShippingBalance Group/promoName right totalShippingBalance_Group/promoName 1.1777777777777778in #BFBFBF bold right totalShippingBalance #BFBFBF bold center Ship Balance $ #BFBFBF bold right Grand Total Group Group/productPromoId center productPromoId 1.3777777777777778in Group/promoName promoName 2.3666666666666667in after #BFBFBF bold center Coupon #BFBFBF CouponSalesReport productPromoId dimension["Group"]["productPromoId"] string promoName dimension["Group"]["promoName"] string totalOrders_Group/promoName measure["totalOrders"] integer Group/promoName SUM totalOrdersAmount_Group/promoName measure["totalOrdersAmount"] float Group/promoName SUM totalShippingCharge_Group/promoName measure["totalShippingCharge"] float Group/promoName SUM totalShippingAmount_Group/promoName measure["totalShippingAmount"] float Group/promoName SUM totalShippingBalance_Group/promoName measure["totalShippingBalance"] float Group/promoName SUM totalOrders measure["totalOrders"] integer SUM totalOrdersAmount measure["totalOrdersAmount"] float SUM totalShippingCharge measure["totalShippingCharge"] float SUM totalShippingAmount measure["totalShippingAmount"] float SUM totalShippingBalance measure["totalShippingBalance"] float SUM totalOrdersPercent Finance.percent(data["totalOrders"], measure["totalOrders"]) float totalOrdersAmountPercent Finance.percent(data["totalOrdersAmount"], measure["totalOrdersAmount"]) float