Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080226-1155>
in
Copyright (c) 2007 <<Your Company Name here>>
Creates a blank report with no predefined content.
Blank Report
/templates/blank_report.gif
static
string
simple
false
text-box
true
Unformatted
static
integer
simple
false
text-box
true
Unformatted
static
integer
simple
false
text-box
true
Unformatted
1
Week
string
2
SKU
string
3
ProductName
string
4
CategoryName
string
5
QuantitySold
integer
6
GS
decimal
7
GMS
decimal
8
GMP
decimal
9
GSP
decimal
10
GP
decimal
11
GMP%
decimal
12
AGP
decimal
13
Rank
integer
Week
Week
SKU
SKU
ProductName
ProductName
QuantitySold
QuantitySold
GS
GS
GMS
GMS
GMP
GMP
GSP
GSP
GP
GP
GMP%
GMP%
AGP
AGP
Rank
Rank
CategoryName
CategoryName
1
Week
string
2
SKU
string
3
ProductName
string
4
CategoryName
string
5
QuantitySold
integer
6
GS
decimal
7
GMS
decimal
8
GMP
decimal
9
GSP
decimal
10
GP
decimal
11
GMP%
decimal
12
AGP
decimal
13
Rank
integer
OFbiz
= totalRows - 1) return false;
{
starschema = starschemas.get(currentRow);
orderDateDateValue = starschema.getString("orderDateDateValue");
orderDateDayName = starschema.getString("orderDateDayName");
orderDateDayOfMonth = starschema.getString("orderDateDayOfMonth");
orderDateMonthName = starschema.getString("orderDateMonthName");
orderDateYearName = starschema.getString("orderDateYearName");
orderDateYearMonthDay = starschema.getString("orderDateYearMonthDay");
orderDateMonthOfYear = starschema.getString("orderDateMonthOfYear");
orderDateDescription = starschema.getString("orderDateDescription");
WeekOfYear = starschema.getString("orderDateWeekOfYear");
SKU = starschema.getString("productProductId");
ProductName = starschema.getString("productInternalName");
CategoryName = starschema.getString("categoryName");
QuantitySold = starschema.getString("quantity");
GS = starschema.getString("GrossSales");
GMS = starschema.getString("GrossMerchandizeSales");
GMP = starschema.getString("GrossMerchandizeProfit");
GSP = starschema.getString("GrossShippingProfit");
GP = starschema.getString("GrossProfit");
salesChannelEnumId = starschema.getString("salesChannelEnumId");
row["Week"] = WeekOfYear;
row["SKU"] = SKU;
row["ProductName"] = ProductName;
row["CategoryName"] = CategoryName;
row["QuantitySold"] = QuantitySold;
row["GS"] = GS;
row["GMS"] = GMS;
row["GMP"] = GMP;
row["GSP"] = GSP;
row["GP"] = GP;
currentRow ++;
}
return true;]]>
PDR Summary Field
NewTabularHierarchy
string
Week
NewTabularHierarchy1
string
SKU
string
ProductName
string
CategoryName
dataSetRow["QuantitySold"]
integer
dataSetRow["GS"]
decimal
dataSetRow["GMP"]
decimal
dataSetRow["GP"]
decimal
dataSetRow["GMP"]/dataSetRow["GMS"]
decimal
dataSetRow["GP"]/dataSetRow["QuantitySold"]
decimal
dataSetRow["Rank"]
integer
PDR
landscape
0.25in
0.25in
0.25in
0.25in
html
new Date()]]>
QuantitySold
QuantitySold
solid
1px
#000000
Products/CategoryName
solid
1px
#000000
Fixed
Fixed
QuantitySold_Products/CategoryName
solid
1px
#000000
GS
GS
GMP
GMP
Products/CategoryName
Fixed
Fixed
GMP_Products/CategoryName
GP
Unformatted
GP
Products/CategoryName
Fixed
Fixed
GP_Products/CategoryName
GMP%
Percent
###0%
GMP%
AGP
Fixed
Fixed
AGP
solid
1px
#000000
Products/CategoryName
solid
1px
#000000
Fixed
Fixed
AGP_Products/CategoryName
solid
1px
#000000
Products
Products/SKU
center
SKU
Products/ProductName
center
ProductName
Products/CategoryName
center
CategoryName
solid
1px
#000000
solid
1px
#000000
solid
1px
#000000
Weeks
Weeks/Week
0pt
center
Week
solid
1px
#000000
solid
1px
#000000
PDR Data Cube
Week
"Week "+dimension["Weeks"]["Week"]
string
SKU
dimension["Products"]["SKU"]
string
QuantitySold
measure["QuantitySold"]
integer
GS
measure["GS"]
decimal
GMP
measure["GMP"]
decimal
GP
measure["GP"]
decimal
GMP%
measure["GMP%"]
decimal
AGP
measure["AGP"]
decimal
ProductName
dimension["Products"]["ProductName"]
string
CategoryName
dimension["Products"]["CategoryName"]
string
QuantitySold_Products/CategoryName
measure["QuantitySold"]
integer
Products/CategoryName
AVE
GMP_Products/CategoryName
measure["GMP"]
decimal
Products/CategoryName
AVE
GP_Products/CategoryName
measure["GP"]
decimal
Products/CategoryName
AVE
AGP_Products/CategoryName
measure["AGP"]
decimal
Products/CategoryName
AVE