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 orderDateWeekOfYear string 8 orderDateDayName string 9 orderDateDescription string 10 countOrder integer 11 quantity integer 12 GS integer 13 GMS integer 14 GMP integer 15 GSP integer 16 GP integer Brand Brand Pod Pod Account Account orderDateYearName orderDateYearName orderDateMonthOfYear orderDateMonthOfYear orderDateMonthName orderDateMonthName orderDateWeekOfYear orderDateWeekOfYear orderDateDayName orderDateDayName orderDateDescription orderDateDescription 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 orderDateWeekOfYear string 8 orderDateDayName string 9 orderDateDescription string 10 countOrder integer 11 quantity integer 12 GS integer 13 GMS integer 14 GMP integer 15 GSP integer 16 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"); countOrder = starschema.getString("countOrder"); quantity = starschema.getString("quantity"); 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["orderDateWeekOfYear"] = orderDateWeekOfYear; row["orderDateDayName"] = orderDateDayName; row["orderDateDescription"] = orderDateDescription; 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 string orderDateWeekOfYear string orderDateDescription string orderDateDayName 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 Daily BIC_DataCube countOrder Account/Account Date/orderDateDescription sans-serif #FFEBCD center Fixed #,##0 countOrder_Account/Account_Date/orderDateDescription Account/Brand Date/orderDateDescription sans-serif #87CEFA center Fixed #,##0 countOrder_Account/Brand_Date/orderDateDescription Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Fixed #,##0 countOrder_Account/Pod_Date/orderDateDescription Date/orderDateDescription sans-serif #6495ED center Fixed #,##0 countOrder_Date/orderDateDescription center Order sans-serif small bold #ECE9D8 center quantity Account/Account Date/orderDateDescription sans-serif #FFEBCD center Fixed #,##0 quantity_Account/Account_Date/orderDateDescription Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Fixed #,##0 quantity_Account/Brand_Date/orderDateDescription Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Fixed #,##0 quantity_Account/Pod_Date/orderDateDescription Date/orderDateDescription sans-serif #6495ED center Fixed #,##0 quantity_Date/orderDateDescription Sold Qty sans-serif small bold #ECE9D8 center GMP Account/Account Date/orderDateDescription sans-serif #FFEBCD center Fixed #,##0 GMP_Account/Account_Date/orderDateDescription Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Fixed #,##0 GMP_Account/Brand_Date/orderDateDescription Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Fixed #,##0 GMP_Account/Pod_Date/orderDateDescription Date/orderDateDescription sans-serif #6495ED center Fixed #,##0 GMP_Date/orderDateDescription GMP$ sans-serif small bold #ECE9D8 center GSP Account/Account Date/orderDateDescription sans-serif #FFEBCD center Fixed #,##0 GSP_Account/Account_Date/orderDateDescription Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Fixed #,##0 GSP_Account/Brand_Date/orderDateDescription Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Fixed #,##0 GSP_Account/Pod_Date/orderDateDescription Date/orderDateDescription sans-serif #6495ED center Fixed #,##0 GSP_Date/orderDateDescription GSP$ sans-serif small bold #ECE9D8 center GP Account/Account Date/orderDateDescription sans-serif #FFEBCD center Fixed #,##0 GP_Account/Account_Date/orderDateDescription Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Fixed #,##0 Brand_GP Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Fixed #,##0 Pod_GP Date/orderDateDescription sans-serif #6495ED center Fixed #,##0 Grand_GP GP$ sans-serif small bold #ECE9D8 center Account/Account Date/orderDateDescription sans-serif #FFEBCD center Percent #,##0% GMP% Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Percent #,##0% Brand_GMP% Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Percent #,##0% Pod_GMP% Date/orderDateDescription sans-serif #6495ED center Percent #,##0% Grand_GMP% GMP% sans-serif small bold #ECE9D8 center Account/Account Date/orderDateDescription sans-serif #FFEBCD center Percent #,##0% GP% Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Percent #,##0% Brand_GP% Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Percent #,##0% Pod_GP% Date/orderDateDescription sans-serif #6495ED center Percent #,##0% Grand_GP% GP% sans-serif small bold #ECE9D8 center Account/Account Date/orderDateDescription sans-serif #FFEBCD center Fixed #,##0.0 AMP Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Fixed #,##0.0 Brand_AMP Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Fixed #,##0.0 Pod_AMP Date/orderDateDescription sans-serif #6495ED center Fixed #,##0.0 Grand_AMP AMP sans-serif small bold #ECE9D8 center Account/Account Date/orderDateDescription sans-serif #FFEBCD center Fixed #,##0.0 AGP Account/Brand Date/orderDateDescription sans-serif scroll #87CEFA center Fixed #,##0.0 Brand_AGP Account/Pod Date/orderDateDescription sans-serif #B0C4DE center Fixed #,##0.0 Pod_AGP Date/orderDateDescription 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 #FFEBCD center Date/orderDateMonthOfYear orderDateMonthOfYear #FFEBCD center Date/orderDateMonthName orderDateMonthName sans-serif #FFEBCD center Date/orderDateWeekOfYear orderDateWeekOfYear sans-serif #FFEBCD center Date/orderDateDescription orderDateDescription sans-serif #ECE9D8 center after sans-serif #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 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 orderDateWeekOfYear dimension["Date"]["orderDateWeekOfYear"] string quantity_Date/orderDateWeekOfYear measure["quantity"] integer Date/orderDateWeekOfYear SUM GS_Date/orderDateWeekOfYear measure["GS"] integer Date/orderDateWeekOfYear SUM GMS_Date/orderDateWeekOfYear measure["GMS"] integer Date/orderDateWeekOfYear SUM GMP_Date/orderDateWeekOfYear measure["GMP"] integer Date/orderDateWeekOfYear SUM GSP_Date/orderDateWeekOfYear measure["GSP"] integer Date/orderDateWeekOfYear SUM GP_Date/orderDateWeekOfYear measure["GP"] integer Date/orderDateWeekOfYear SUM orderDateDescription dimension["Date"]["orderDateDescription"] string quantity_Date/orderDateDescription measure["quantity"] integer Date/orderDateDescription SUM GS_Date/orderDateDescription measure["GS"] integer Date/orderDateDescription SUM GMS_Date/orderDateDescription measure["GMS"] integer Date/orderDateDescription SUM GMP_Date/orderDateDescription measure["GMP"] integer Date/orderDateDescription SUM GSP_Date/orderDateDescription measure["GSP"] integer Date/orderDateDescription SUM GP_Date/orderDateDescription measure["GP"] integer Date/orderDateDescription SUM Brand dimension["Account"]["Brand"] string Pod dimension["Account"]["Pod"] string Account dimension["Account"]["Account"] string quantity_Account/Account_Date/orderDateDescription measure["quantity"] integer Account/Account Date/orderDateDescription SUM GS_Account/Account_Date/orderDateDescription measure["GS"] integer Account/Account Date/orderDateDescription SUM GMS_Account/Account_Date/orderDateDescription measure["GMS"] integer Account/Account Date/orderDateDescription SUM GMP_Account/Account_Date/orderDateDescription measure["GMP"] integer Account/Account Date/orderDateDescription SUM GSP_Account/Account_Date/orderDateDescription measure["GSP"] integer Account/Account Date/orderDateDescription SUM GP_Account/Account_Date/orderDateDescription measure["GP"] integer Account/Account Date/orderDateDescription SUM GMP% if ((data["GMP_Account/Account_Date/orderDateDescription"] != null) && (data["GMS_Account/Account_Date/orderDateDescription"] != null)) { data["GMP_Account/Account_Date/orderDateDescription"]/data["GMS_Account/Account_Date/orderDateDescription"] } decimal GP% if ((data["GP_Account/Account_Date/orderDateDescription"] != null) && (data["GS_Account/Account_Date/orderDateDescription"] != null)) { data["GP_Account/Account_Date/orderDateDescription"]/data["GS_Account/Account_Date/orderDateDescription"] } decimal AMP if ((data["GMP_Account/Account_Date/orderDateDescription"] != null) && (data["quantity_Account/Account_Date/orderDateDescription"] != null)) { data["GMP_Account/Account_Date/orderDateDescription"]/data["quantity_Account/Account_Date/orderDateDescription"] } float AGP if ((data["GP_Account/Account_Date/orderDateDescription"] != null) && (data["quantity_Account/Account_Date/orderDateDescription"] != null)) { data["GP_Account/Account_Date/orderDateDescription"]/data["quantity_Account/Account_Date/orderDateDescription"] } float quantity_Account/Brand_Date/orderDateDescription measure["quantity"] integer Account/Brand Date/orderDateDescription SUM GS_Account/Brand_Date/orderDateDescription measure["GS"] integer Account/Brand Date/orderDateDescription SUM GMS_Account/Brand_Date/orderDateDescription measure["GMS"] integer Account/Brand Date/orderDateDescription SUM GMP_Account/Brand_Date/orderDateDescription measure["GMP"] integer Account/Brand Date/orderDateDescription SUM GSP_Account/Brand_Date/orderDateDescription measure["GSP"] integer Account/Brand Date/orderDateDescription SUM GP_Account/Brand_Date/orderDateDescription measure["GP"] integer Account/Brand Date/orderDateDescription SUM Brand_TOTAL dimension["Account"]["Brand"]+" TOTAL" string quantity_Account/Pod_Date/orderDateDescription measure["quantity"] integer Account/Pod Date/orderDateDescription SUM GS_Account/Pod_Date/orderDateDescription measure["GS"] integer Account/Pod Date/orderDateDescription SUM GMS_Account/Pod_Date/orderDateDescription measure["GMS"] integer Account/Pod Date/orderDateDescription SUM GMP_Account/Pod_Date/orderDateDescription measure["GMP"] integer Account/Pod Date/orderDateDescription SUM GSP_Account/Pod_Date/orderDateDescription measure["GSP"] integer Account/Pod Date/orderDateDescription SUM GP_Account/Pod_Date/orderDateDescription measure["GP"] integer Account/Pod Date/orderDateDescription SUM Pod_TOTAL dimension["Account"]["Pod"]+" TOTAL" string Pod_GMP% if ((data["GMP_Account/Pod_Date/orderDateDescription"] != null) && (data["GMS_Account/Pod_Date/orderDateDescription"] != null)) { data["GMP_Account/Pod_Date/orderDateDescription"]/data["GMS_Account/Pod_Date/orderDateDescription"] } decimal Brand_GMP% if ((data["GMP_Account/Brand_Date/orderDateDescription"] != null) && (data["GMS_Account/Brand_Date/orderDateDescription"] !=null)) { data["GMP_Account/Brand_Date/orderDateDescription"]/data["GMS_Account/Brand_Date/orderDateDescription"] } decimal Pod_GP% if ((data["GP_Account/Pod_Date/orderDateDescription"] != null) && (data["GS_Account/Pod_Date/orderDateDescription"] != null)) { data["GP_Account/Pod_Date/orderDateDescription"]/data["GS_Account/Pod_Date/orderDateDescription"] } decimal Brand_GP% if ((data["GP_Account/Brand_Date/orderDateDescription"] != null) && (data["GS_Account/Brand_Date/orderDateDescription"] != null)) { data["GP_Account/Brand_Date/orderDateDescription"]/data["GS_Account/Brand_Date/orderDateDescription"] } decimal Pod_AMP if ((data["GMP_Account/Pod_Date/orderDateDescription"] != null) && (data["quantity_Account/Pod_Date/orderDateDescription"] != null)) { data["GMP_Account/Pod_Date/orderDateDescription"]/data["quantity_Account/Pod_Date/orderDateDescription"] } float Brand_AMP if ((data["GMP_Account/Brand_Date/orderDateDescription"] != null) && (data["quantity_Account/Brand_Date/orderDateDescription"] != null)) { data["GMP_Account/Brand_Date/orderDateDescription"]/data["quantity_Account/Brand_Date/orderDateDescription"] } float Pod_AGP if ((data["GP_Account/Pod_Date/orderDateDescription"] != null) && (data["quantity_Account/Pod_Date/orderDateDescription"] != null)) { data["GP_Account/Pod_Date/orderDateDescription"]/data["quantity_Account/Pod_Date/orderDateDescription"] } float Brand_AGP if ((data["GP_Account/Brand_Date/orderDateDescription"] != null) && (data["quantity_Account/Brand_Date/orderDateDescription"] != null)) { data["GP_Account/Brand_Date/orderDateDescription"]/data["quantity_Account/Brand_Date/orderDateDescription"] } float Grand_GMP% if ((data["GMP_Date/orderDateDescription"] != null) && (data["GMS_Date/orderDateDescription"] != null)) { data["GMP_Date/orderDateDescription"]/data["GMS_Date/orderDateDescription"] } decimal Grand_GP% if ((data["GP_Date/orderDateDescription"] != null) && (data["GS_Date/orderDateDescription"] != null)) { data["GP_Date/orderDateDescription"]/data["GS_Date/orderDateDescription"] } decimal Grand_AMP if ((data["GMP_Date/orderDateDescription"] != null) && (data["quantity_Date/orderDateDescription"] != null)) { data["GMP_Date/orderDateDescription"]/data["quantity_Date/orderDateDescription"] } float Grand_AGP if ((data["GP_Date/orderDateDescription"] != null) && (data["quantity_Date/orderDateDescription"] != null)) { data["GP_Date/orderDateDescription"]/data["quantity_Date/orderDateDescription"] } float Account_GP data["GMP_Account/Account_Date/orderDateDescription"]+data["GSP_Account/Account_Date/orderDateDescription"] integer Pod_GP data["GMP_Account/Pod_Date/orderDateDescription"]+data["GSP_Account/Pod_Date/orderDateDescription"] integer Brand_GP data["GMP_Account/Brand_Date/orderDateDescription"]+data["GSP_Account/Brand_Date/orderDateDescription"] integer Grand_GP data["GMP_Date/orderDateDescription"]+data["GSP_Date/orderDateDescription"] integer countOrder_Account/Brand_Date/orderDateDescription measure["countOrder"] integer Account/Brand Date/orderDateDescription SUM countOrder_Account/Pod_Date/orderDateDescription measure["countOrder"] integer Account/Pod Date/orderDateDescription SUM countOrder_Date/orderDateDescription measure["countOrder"] integer Date/orderDateDescription SUM countOrder_Account/Account_Date/orderDateDescription measure["countOrder"] integer Account/Account Date/orderDateDescription SUM orderDateMonthOfYear dimension["Date"]["orderDateMonthOfYear"] string