Copyright (c) 2007 <<Your Company Name here>> Eclipse BIRT Designer Version 3.7.1.v20110905 Build <3.7.1.v20110913-1734> Creates a blank report with no predefined content. BIC_DataCube.BIC.x integer false BIC_DataCube.BIC.y integer false BIC_DataCube.Account.NewTabularHierarchy1.x integer false BIC_DataCube.Account.NewTabularHierarchy1.y integer false BIC_DataCube.BIC.width integer false BIC_DataCube.BIC.height integer false BIC_DataCube.Account.NewTabularHierarchy1.width integer false BIC_DataCube.Account.NewTabularHierarchy1.height integer false SaleOrder_DataCube.Account.x integer false SaleOrder_DataCube.Account.y integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.x integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.y integer false SaleOrder_DataCube.Account.width integer false SaleOrder_DataCube.Account.height integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.width integer false SaleOrder_DataCube.DateGroup.NewTabularHierarchy3.height integer false 284 29 70 35 150 200 150 200 280 17 32 39 150 200 150 200 in Blank Report /templates/blank_report.gif auto layout static string true simple text-box Unformatted static false date true simple text-box Unformatted static false date true simple text-box Unformatted static false date true simple text-box Unformatted static false integer true simple text-box Unformatted static false integer true simple text-box Unformatted static false integer true simple text-box Unformatted 1 Brand string 2 Pod string 3 Account string 4 orderDateYearName string 5 orderDateMonthOfYear string 6 orderDateMonthName string 7 countOrder integer 8 quantity integer 9 GS integer 10 GMS integer 11 GMP integer 12 GSP integer 13 GP integer Brand Brand Pod Pod Account Account orderDateYearName orderDateYearName orderDateMonthOfYear orderDateMonthOfYear orderDateMonthName orderDateMonthName countOrder countOrder quantity quantity GS GS GMS GMS GMP GMP GSP GSP GP GP 1 Brand string 2 Pod string 3 Account string 4 orderDateYearName string 5 orderDateMonthOfYear string 6 orderDateMonthName string 7 countOrder integer 8 quantity integer 9 GS integer 10 GMS integer 11 GMP integer 12 GSP integer 13 GP integer OFbiz totalRows - 1) return false; { starschema = starschemas.get(currentRow); orderDateDescription = starschema.getString("orderDateDescription"); orderDateDayName = starschema.getString("orderDateDayName"); orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth"); orderDateMonthName = starschema.getString("orderDateMonthName"); orderDateYearName = starschema.getString("orderDateYearName"); orderDateWeekOfYear = starschema.getString("orderDateWeekOfYear"); orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay"); orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear"); brand = starschema.getString("brand"); pod = starschema.getString("pod"); account = starschema.getString("account"); quantity = starschema.getString("quantity"); countOrder = starschema.getString("countOrder"); GS = starschema.getString("GS"); GMS = starschema.getString("GMS"); GMP = starschema.getString("GMP"); GSP = starschema.getString("GSP"); GP = starschema.getString("GP"); row["Brand"] = brand; row["Pod"] = pod; row["Account"] = account; row["orderDateYearName"] = orderDateYearName; row["orderDateMonthOfYear"] = orderDateMonthOfYear; row["orderDateMonthName"] = orderDateMonthName; row["countOrder"] = countOrder; row["quantity"] = quantity; row["GS"] = GS; row["GMS"] = GMS; row["GMP"] = GMP; row["GSP"] = GSP; row["GP"] = GP; currentRow ++; } return true;]]> NewTabularHierarchy string orderDateYearName string orderDateMonthOfYear string orderDateMonthName NewTabularHierarchy1 string Brand string Pod string Account dataSetRow["countOrder"] integer dataSetRow["quantity"] integer dataSetRow["GS"] integer dataSetRow["GMS"] integer dataSetRow["GMP"] integer dataSetRow["GSP"] integer dataSetRow["GP"] integer BIC custom 10in 20in landscape 0.5in 0.5in 0.5in 0.5in sans-serif html new Date()]]> sans-serif xx-large normal 1pt 20pt center Sales Report Monthly BIC_DataCube countOrder Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Fixed #,##0 countOrder_Account/Account_Date/orderDateMonthName Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Fixed #,##0 countOrder_Account/Brand_Date/orderDateMonthName Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Fixed #,##0 countOrder_Account/Pod_Date/orderDateMonthName Date/orderDateMonthName sans-serif #6495ED center Fixed #,##0 countOrder_Date/orderDateMonthName Order sans-serif small bold #ECE9D8 center quantity Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Fixed #,##0 quantity_Account/Account_Date/orderDateMonthName Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Fixed #,##0 quantity_Account/Brand_Date/orderDateMonthName Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Fixed #,##0 quantity_Account/Pod_Date/orderDateMonthName Date/orderDateMonthName sans-serif #6495ED center Fixed #,##0 quantity_Date/orderDateMonthName Sold Qty sans-serif small bold #ECE9D8 center GMP Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Fixed #,##0 GMP_Account/Account_Date/orderDateMonthName Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Fixed #,##0 GMP_Account/Brand_Date/orderDateMonthName Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Fixed #,##0 GMP_Account/Pod_Date/orderDateMonthName Date/orderDateMonthName sans-serif #6495ED center Fixed #,##0 GMP_Date/orderDateMonthName GMP$ sans-serif small bold #ECE9D8 center GSP Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Fixed #,##0 GSP_Account/Account_Date/orderDateMonthName Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Fixed #,##0 GSP_Account/Brand_Date/orderDateMonthName Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Fixed #,##0 GSP_Account/Pod_Date/orderDateMonthName Date/orderDateMonthName sans-serif #6495ED center Fixed #,##0 GSP_Date/orderDateMonthName GSP$ sans-serif small bold #ECE9D8 center GP Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Fixed #,##0 GP_Account/Account_Date/orderDateMonthName Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Fixed #,##0 Brand_GP Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Fixed #,##0 Pod_GP Date/orderDateMonthName sans-serif #6495ED center Fixed #,##0 Grand_GP GP$ sans-serif small bold #ECE9D8 center Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Percent #,##0% GMP% Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Percent #,##0% Brand_GMP% Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Percent #,##0% Pod_GMP% Date/orderDateMonthName sans-serif #6495ED center Percent #,##0% Grand_GMP% GMP% sans-serif small bold #ECE9D8 center Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Percent #,##0% GP% Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Percent #,##0% Brand_GP% Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Percent #,##0% Pod_GP% Date/orderDateMonthName sans-serif #6495ED center Percent #,##0% Grand_GP% GP% sans-serif small bold #ECE9D8 center Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Fixed #,##0.0 AMP Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Fixed #,##0.0 Brand_AMP Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Fixed #,##0.0 Pod_AMP Date/orderDateMonthName sans-serif #6495ED center Fixed #,##0.0 Grand_AMP AMP sans-serif small bold #ECE9D8 center Account/Account Date/orderDateMonthName sans-serif #FFEBCD center Fixed #,##0.0 AGP Account/Brand Date/orderDateMonthName sans-serif #87CEFA center Fixed #,##0.0 Brand_AGP Account/Pod Date/orderDateMonthName sans-serif #B0C4DE center Fixed #,##0.0 Pod_AGP Date/orderDateMonthName sans-serif #6495ED center Fixed #,##0.0 Grand_AGP AGP sans-serif small bold #ECE9D8 center Grand Total sans-serif #ECE9D8 Account Account/Brand Brand sans-serif small bold #ECE9D8 Total sans-serif #ECE9D8 Account/Pod Pod sans-serif small bold #ECE9D8 Total sans-serif #ECE9D8 Account/Account Account sans-serif small bold #F5F5DC after Date Date/orderDateYearName orderDateYearName sans-serif #FFEFD5 center Date/orderDateMonthOfYear orderDateMonthOfYear sans-serif #FFEFD5 center Date/orderDateMonthName orderDateMonthName sans-serif #ECE9D8 center after #FFFFFF quantity measure["quantity"] integer SUM GS measure["GS"] integer SUM GMS measure["GMS"] integer SUM GMP measure["GMP"] integer SUM GSP measure["GSP"] integer SUM GP measure["GP"] integer SUM orderDateYearName dimension["Date"]["orderDateYearName"] string quantity_Date/orderDateYearName measure["quantity"] integer Date/orderDateYearName SUM GS_Date/orderDateYearName measure["GS"] integer Date/orderDateYearName SUM GMS_Date/orderDateYearName measure["GMS"] integer Date/orderDateYearName SUM GMP_Date/orderDateYearName measure["GMP"] integer Date/orderDateYearName SUM GSP_Date/orderDateYearName measure["GSP"] integer Date/orderDateYearName SUM GP_Date/orderDateYearName measure["GP"] integer Date/orderDateYearName SUM orderDateMonthOfYear dimension["Date"]["orderDateMonthOfYear"] string quantity_Date/orderDateMonthOfYear measure["quantity"] integer Date/orderDateMonthOfYear SUM GS_Date/orderDateMonthOfYear measure["GS"] integer Date/orderDateMonthOfYear SUM GMS_Date/orderDateMonthOfYear measure["GMS"] integer Date/orderDateMonthOfYear SUM GMP_Date/orderDateMonthOfYear measure["GMP"] integer Date/orderDateMonthOfYear SUM GSP_Date/orderDateMonthOfYear measure["GSP"] integer Date/orderDateMonthOfYear SUM GP_Date/orderDateMonthOfYear measure["GP"] integer Date/orderDateMonthOfYear SUM orderDateMonthName dimension["Date"]["orderDateMonthName"] string quantity_Date/orderDateMonthName measure["quantity"] integer Date/orderDateMonthName SUM GS_Date/orderDateMonthName measure["GS"] integer Date/orderDateMonthName SUM GMS_Date/orderDateMonthName measure["GMS"] integer Date/orderDateMonthName SUM GMP_Date/orderDateMonthName measure["GMP"] integer Date/orderDateMonthName SUM GSP_Date/orderDateMonthName measure["GSP"] integer Date/orderDateMonthName SUM GP_Date/orderDateMonthName measure["GP"] integer Date/orderDateMonthName SUM Brand dimension["Account"]["Brand"] string quantity_Account/Brand_Date/orderDateMonthName measure["quantity"] integer Account/Brand Date/orderDateMonthName SUM GS_Account/Brand_Date/orderDateMonthName measure["GS"] integer Account/Brand Date/orderDateMonthName SUM GMS_Account/Brand_Date/orderDateMonthName measure["GMS"] integer Account/Brand Date/orderDateMonthName SUM GMP_Account/Brand_Date/orderDateMonthName measure["GMP"] integer Account/Brand Date/orderDateMonthName SUM GSP_Account/Brand_Date/orderDateMonthName measure["GSP"] integer Account/Brand Date/orderDateMonthName SUM GP_Account/Brand_Date/orderDateMonthName measure["GP"] integer Account/Brand Date/orderDateMonthName SUM Pod dimension["Account"]["Pod"] string quantity_Account/Pod_Date/orderDateMonthName measure["quantity"] integer Account/Pod Date/orderDateMonthName SUM GS_Account/Pod_Date/orderDateMonthName measure["GS"] integer Account/Pod Date/orderDateMonthName SUM GMS_Account/Pod_Date/orderDateMonthName measure["GMS"] integer Account/Pod Date/orderDateMonthName SUM GMP_Account/Pod_Date/orderDateMonthName measure["GMP"] integer Account/Pod Date/orderDateMonthName SUM GSP_Account/Pod_Date/orderDateMonthName measure["GSP"] integer Account/Pod Date/orderDateMonthName SUM GP_Account/Pod_Date/orderDateMonthName measure["GP"] integer Account/Pod Date/orderDateMonthName SUM Account dimension["Account"]["Account"] string quantity_Account/Account_Date/orderDateMonthName measure["quantity"] integer Account/Account Date/orderDateMonthName SUM GS_Account/Account_Date/orderDateMonthName measure["GS"] integer Account/Account Date/orderDateMonthName SUM GMS_Account/Account_Date/orderDateMonthName measure["GMS"] integer Account/Account Date/orderDateMonthName SUM GMP_Account/Account_Date/orderDateMonthName measure["GMP"] integer Account/Account Date/orderDateMonthName SUM GSP_Account/Account_Date/orderDateMonthName measure["GSP"] integer Account/Account Date/orderDateMonthName SUM GP_Account/Account_Date/orderDateMonthName measure["GP"] integer Account/Account Date/orderDateMonthName SUM GMP% if ((data["GMP_Account/Account_Date/orderDateMonthName"] != null) && (data["GMS_Account/Account_Date/orderDateMonthName"] != null)) { data["GMP_Account/Account_Date/orderDateMonthName"]/data["GMS_Account/Account_Date/orderDateMonthName"] } decimal GP% if ((data["GP_Account/Account_Date/orderDateMonthName"] != null) && (data["GS_Account/Account_Date/orderDateMonthName"] != null)) { data["GP_Account/Account_Date/orderDateMonthName"]/data["GS_Account/Account_Date/orderDateMonthName"] } decimal AMP if ((data["GMP_Account/Account_Date/orderDateMonthName"] != null) && (data["quantity_Account/Account_Date/orderDateMonthName"] != null)) { data["GMP_Account/Account_Date/orderDateMonthName"]/data["quantity_Account/Account_Date/orderDateMonthName"] } float AGP if ((data["GP_Account/Account_Date/orderDateMonthName"] != null) && (data["quantity_Account/Account_Date/orderDateMonthName"] != null)) { data["GP_Account/Account_Date/orderDateMonthName"]/data["quantity_Account/Account_Date/orderDateMonthName"] } float Brand_TOTAL dimension["Account"]["Brand"]+" TOTAL" string Pod_TOTAL dimension["Account"]["Pod"]+" TOTAL" string Pod_GMP% if ((data["GMP_Account/Pod_Date/orderDateMonthName"] != null) && (data["GMS_Account/Pod_Date/orderDateMonthName"] != null)) { data["GMP_Account/Pod_Date/orderDateMonthName"]/data["GMS_Account/Pod_Date/orderDateMonthName"] } decimal Brand_GMP% if ((data["GMP_Account/Brand_Date/orderDateMonthName"] != null) && (data["GMS_Account/Brand_Date/orderDateMonthName"] != null)) { data["GMP_Account/Brand_Date/orderDateMonthName"]/data["GMS_Account/Brand_Date/orderDateMonthName"] } decimal Grand_GMP% if ((data["GMP_Date/orderDateMonthName"] != null) && (data["GMS_Date/orderDateMonthName"] != null)) { data["GMP_Date/orderDateMonthName"]/data["GMS_Date/orderDateMonthName"] } decimal Pod_GP% if ((data["GP_Account/Pod_Date/orderDateMonthName"] != null) && (data["GS_Account/Pod_Date/orderDateMonthName"] != null)) { data["GP_Account/Pod_Date/orderDateMonthName"]/data["GS_Account/Pod_Date/orderDateMonthName"] } decimal Brand_GP% if ((data["GP_Account/Brand_Date/orderDateMonthName"] != null) && (data["GS_Account/Brand_Date/orderDateMonthName"] != null)) { data["GP_Account/Brand_Date/orderDateMonthName"]/data["GS_Account/Brand_Date/orderDateMonthName"] } decimal Grand_GP% if ((data["GP_Date/orderDateMonthName"] != null) && (data["GS_Date/orderDateMonthName"] != null)) { data["GP_Date/orderDateMonthName"]/data["GS_Date/orderDateMonthName"] } decimal Pod_AMP if ((data["GMP_Account/Pod_Date/orderDateMonthName"] != null) && (data["quantity_Account/Pod_Date/orderDateMonthName"] != null)) { data["GMP_Account/Pod_Date/orderDateMonthName"]/data["quantity_Account/Pod_Date/orderDateMonthName"] } float Brand_AMP if ((data["GMP_Account/Brand_Date/orderDateMonthName"] != null) && (data["quantity_Account/Brand_Date/orderDateMonthName"] != null)) { data["GMP_Account/Brand_Date/orderDateMonthName"]/data["quantity_Account/Brand_Date/orderDateMonthName"] } float Grand_AMP if ((data["GMP_Date/orderDateMonthName"] != null) && (data["quantity_Date/orderDateMonthName"] != null)) { data["GMP_Date/orderDateMonthName"]/data["quantity_Date/orderDateMonthName"] } float Pod_AGP if ((data["GP_Account/Pod_Date/orderDateMonthName"] != null) && (data["quantity_Account/Pod_Date/orderDateMonthName"] != null)) { data["GP_Account/Pod_Date/orderDateMonthName"]/data["quantity_Account/Pod_Date/orderDateMonthName"] } float Brand_AGP if ((data["GP_Account/Brand_Date/orderDateMonthName"] != null) && (data["quantity_Account/Brand_Date/orderDateMonthName"] != null)) { data["GP_Account/Brand_Date/orderDateMonthName"]/data["quantity_Account/Brand_Date/orderDateMonthName"] } float Grand_AGP if ((data["GP_Date/orderDateMonthName"] != null) && (data["quantity_Date/orderDateMonthName"] != null)) { data["GP_Date/orderDateMonthName"]/data["quantity_Date/orderDateMonthName"] } float Account_GP data["GMP_Account/Account_Date/orderDateMonthName"]+data["GSP_Account/Account_Date/orderDateMonthName"] integer Pod_GP data["GMP_Account/Pod_Date/orderDateMonthName"]+data["GSP_Account/Pod_Date/orderDateMonthName"] integer Brand_GP data["GMP_Account/Brand_Date/orderDateMonthName"]+data["GSP_Account/Brand_Date/orderDateMonthName"] integer Grand_GP data["GMP_Date/orderDateMonthName"]+data["GSP_Date/orderDateMonthName"] integer countOrder_Account/Brand_Date/orderDateMonthName measure["countOrder"] integer Account/Brand Date/orderDateMonthName SUM countOrder_Account/Pod_Date/orderDateMonthName measure["countOrder"] integer Account/Pod Date/orderDateMonthName SUM countOrder_Date/orderDateMonthName measure["countOrder"] integer Date/orderDateMonthName SUM countOrder_Account/Account_Date/orderDateMonthName measure["countOrder"] integer Account/Account Date/orderDateMonthName SUM