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