Copyright (c) 2006 <<Your Company Name here>>
Eclipse BIRT Designer Version 4.3.1.v201309091055 Build <4.3.1.v20130917-1035>
This template will create a report having a single header with multiple rows of data.
receipts
in
MaximoSystemLibrary.maximoTheme
Maximo List Report Template
auto layout
MaximoSystemLibrary.rptlibrary
MaximoSystemLibrary
static
false
string
1=1
text-box
Unformatted
static
false
string
text-box
Unformatted
true
static
false
string
text-box
Unformatted
true
static
false
string
text-box
Unformatted
1
itemcnt
string
2
reqyear
string
3
reqmonth
string
4
curbal
string
5
itemnum
string
6
minlevel
string
7
poqty
string
8
bnum
string
9
description
string
10
descr
string
itemcnt
reqyear
reqmonth
curbal
assetnum
minlevel
poqty
bnum
description
itemqty
descr
1
itemcnt
string
2
reqyear
string
3
reqmonth
string
4
curbal
string
5
itemnum
string
6
minlevel
string
7
poqty
string
8
bnum
string
9
description
string
10
descr
string
maximoDataSource
0
+" and inv.itemnum='00974951' "
//--and inv.REORDER=1
+" and inv.minlevel>0 "
+" group by inv.itemnum,item.description,inb.curbal,inv.minlevel,inv.location ,inb.binnum,c.DESCRIPTION "
+" )"
+" select mf.itemnum,mf.itemcnt ,DATENAME( MONTH, DATEADD( MONTH, cast(mf.reqmonth as INT), -1)) +mf.reqyear AS 'MonthName',(it.curbal-mf.itemcnt) AS 'ShortQty',"
+" it.description,it.curbal,it.minlevel,it.bnum,it.poqty,it.descr "
+" from mf inner join it on mf.itemnum=it.itemnum and mf.res=it.loc "
+" where mf.itemnum='00974951' "
+" group by mf.itemnum,"
+" mf.itemcnt,mf.reqyear,mf.reqmonth,it.description,it.curbal,it.minlevel,it.bnum,it.poqty,it.descr "
+" order by reqyear desc,reqmonth "
;
maximoDataSet.setQuery(sqlText);]]>
NewTabularHierarchy
string
itemnum
NewTabularHierarchy1
string
reqmonth
sum
false
dataSetRow["curbal"]
integer
true
sum
false
dataSetRow["reqyear"]
integer
true
receipts
landscape
auto
auto
auto
auto
9.552083333333334in
receipts
all
length(row["itemnum"])<=0
itemnum
itemnum
dataSetRow["itemnum"]
string
itemqty
itemqty
dataSetRow["itemqty"]
integer
description
description
dataSetRow["description"]
string
itemcnt
itemcnt
dataSetRow["itemcnt"]
string
curbal
curbal
dataSetRow["curbal"]
string
minlevel
minlevel
dataSetRow["minlevel"]
string
reqyear
reqyear
dataSetRow["reqyear"]
string
reqmonth
reqmonth
dataSetRow["reqmonth"]
string
poqty
poqty
dataSetRow["poqty"]
string
bnum
bnum
dataSetRow["bnum"]
string
descr
descr
dataSetRow["descr"]
string
Diff
Diff
dataSetRow["curbal"]-dataSetRow["itemcnt"]
string
true
1.125in
1.7083333333333333in
0.625in
0.7395833333333334in
0.6979166666666666in
0.6979166666666666in
0.8020833333333334in
0.8854166666666666in
0.9895833333333334in
0.6041666666666666in
1.375in
white
none
none
none
none
11
1
Data Cube
curbal
Group/itemnum
Year/reqmonth
solid
thin
337px
curbal_Group/itemnum_Year/reqmonth_1
CurBal
solid
thin
reqyear
Group/itemnum
Year/reqmonth
287px
reqyear_Group/itemnum_Year/reqmonth
ShortQty
Group
Group/itemnum
itemnum_1
479px
Year
Year/reqmonth
reqmonth
16pt
Item Num
itemnum_1
dimension["Group"]["itemnum"]
string
reqmonth
dimension["Year"]["reqmonth"]
string
curbal_Group/itemnum_Year/reqmonth
integer
Group/itemnum
SUM
Expression
measure["curbal"]
reqyear_Group/itemnum_Year/reqmonth
integer
Group/itemnum
Year/reqmonth
SUM
Expression
measure["reqyear"]
curbal_Group/itemnum_Year/reqmonth_1
measure["curbal"]
integer
Group/itemnum
Year/reqmonth
SUM
|
#444E68
none
none
none
none
11
1
scroll
0%
0%
repeat
serif
10pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
BOM Report
|
#444E68
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Item Num
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Description
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Quantity Required
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Cur Bal
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Short Qty
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Min Lvl
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Req Year
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Req Month
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Total PO Qty
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Bin Num
|
scroll
0%
0%
repeat
serif
8pt
bold
normal
normal
white
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Legacy T&RS Group
|
Grp
row["itemnum"]
row["itemnum"]
false
false
#C0C7D6
scroll
0%
0%
repeat
serif
10pt
bold
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
itemnum
|
1
1
scroll
0%
0%
repeat
serif
10pt
bold
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
description
|
8
1
|
scroll
0%
0%
repeat
serif
10pt
bold
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
left
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
descr
|
dotted
thin
all
row["curbal"]==0
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
all
true
itemnum
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
all
true
description
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
itemcnt
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
curbal
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
Diff
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
minlevel
|
|
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
poqty
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
bnum
|
scroll
0%
0%
repeat
serif
10pt
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
center
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
hidden
all
true
descr
|