Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408> in /templates/blank_report.gif ltr 1 orderId string 2 orderItemSeqId string 3 orderStatus string 4 saleChannel string 5 quantity string 6 extGrossAmount string 7 orderDateDayOfMonth string 8 orderDateMonthOfYear string 9 orderDateYearName string 10 price string 11 stock string 12 productId string 13 internalName string orderId orderItemSeqId orderStatus saleChannel quantity extGrossAmount orderDateDayOfMonth orderDateMonthOfYear orderDateYearName price stock productId internalName 1 orderId string 2 orderItemSeqId string 3 orderStatus string 4 saleChannel string 5 quantity string 6 extGrossAmount string 7 orderDateDayOfMonth string 8 orderDateMonthOfYear string 9 orderDateYearName string 10 price string 11 stock string 12 productId string 13 internalName string OFBIZ = totalRow) return false; salesOrderItemStarSchema = salesOrderItemStarSchemas.get(countOfRow); input = new HashMap(); input.put("productId", salesOrderItemStarSchema.getString("productProductId")); input.put("userLogin", userLogin); QOH = 0; try { result = dispatcher.runSync("getInventoryValuationList", input); inventorys = result.get("inventoryValuationList"); QOH = inventorys.get(0).get("totalQuantityOnHand"); } catch (e) { Debug.logError(e, module); } price = 0; internalName = "None"; input = new HashMap(); try { product = delegator.findOne("Product",UtilMisc.toMap("productId", salesOrderItemStarSchema.getString("productProductId")), false); if(product!=null){ input.put("product", product); input.put("userLogin", userLogin); result = dispatcher.runSync("calculateProductPrice", input); price = result.get("price"); if(product.get("internalName")){ internalName = product.get("internalName"); } } } catch (e) { Debug.logError(e, module); } row["orderId"] = salesOrderItemStarSchema.getString("orderId"); row["orderItemSeqId"] = salesOrderItemStarSchema.getString("orderItemSeqId"); row["orderStatus"] = salesOrderItemStarSchema.getString("statusId"); row["saleChannel"] = salesOrderItemStarSchema.getString("salesChannelEnumId"); row["quantity"] = salesOrderItemStarSchema.getString("quantity"); row["extGrossAmount"] = salesOrderItemStarSchema.getString("extGrossAmount"); row["orderDateDayOfMonth"] = salesOrderItemStarSchema.getString("orderDateDayOfMonth"); row["orderDateMonthOfYear"] = salesOrderItemStarSchema.getString("orderDateMonthOfYear"); row["orderDateYearName"] = salesOrderItemStarSchema.getString("orderDateYearName"); row["price"] = price; row["stock"] = QOH; row["productId"]= salesOrderItemStarSchema.getString("productProductId"); row["internalName"] = internalName; countOfRow ++; return true;]]> NewTabularHierarchy string productId string internalName string price string stock string orderDateMonthOfYear count dataSetRow["orderItemSeqId"] integer sum dataSetRow["quantity"] float sum dataSetRow["extGrossAmount"] float SalesOrderItemStarSchema html new Date()]]> larger bold center auto DataCube orderItemSeqId Group/orderDateMonthOfYear orderItemSeqId_Group/orderDateMonthOfYear 0.9888888888888889in Group/productId orderItemSeqId_Group/productId orderItemSeqId bold Items 0.32222222222222224in quantity Group/orderDateMonthOfYear quantity_Group/orderDateMonthOfYear 0.9888888888888889in Group/productId quantity_Group/productId quantity bold QTY extGrossAmount Group/orderDateMonthOfYear extGrossAmount_Group/orderDateMonthOfYear 0.9888888888888889in Group/productId extGrossAmount_Group/productId extGrossAmount bold ToTal bold right Grand Total Group Group/productId productId 0.8777777777777778in bold right productId_TOTAL Group/internalName internalName 2.3222222222222224in Group/price price 0.5666666666666667in Group/stock stock 0.6in Group/orderDateMonthOfYear orderDateMonthOfYear 0.5666666666666667in after 4.844444444444444in 0.8333333333333334in 2.2888888888888888in 0.6in 0.5888888888888889in 0.5444444444444444in bold auto bold auto bold auto bold auto bold auto productId dimension["Group"]["productId"] string internalName dimension["Group"]["internalName"] string price dimension["Group"]["price"] string stock dimension["Group"]["stock"] string orderDateMonthOfYear dimension["Group"]["orderDateMonthOfYear"] string orderItemSeqId_Group/orderDateMonthOfYear measure["orderItemSeqId"] integer Group/orderDateMonthOfYear SUM quantity_Group/orderDateMonthOfYear measure["quantity"] float Group/orderDateMonthOfYear SUM extGrossAmount_Group/orderDateMonthOfYear measure["extGrossAmount"] float Group/orderDateMonthOfYear SUM orderItemSeqId_Group/productId measure["orderItemSeqId"] integer Group/productId SUM quantity_Group/productId measure["quantity"] float Group/productId SUM extGrossAmount_Group/productId measure["extGrossAmount"] float Group/productId SUM productId_TOTAL dimension["Group"]["productId"]+" TOTAL" string orderItemSeqId measure["orderItemSeqId"] integer SUM quantity measure["quantity"] float SUM extGrossAmount measure["extGrossAmount"] float SUM