Eclipse BIRT Designer Version 4.3.1.v201309091055 Build <4.3.1.v20130918-1142>
in
/templates/blank_report.gif
auto layout
ltr
org.eclipse.birt.report.data.oda.sampledb.Driver
jdbc:classicmodels:sampledb
ClassicModels
EMPLOYEENUMBER
EMPLOYEENUMBER
LASTNAME
LASTNAME
FIRSTNAME
FIRSTNAME
EXTENSION
EXTENSION
EMAIL
EMAIL
OFFICECODE
OFFICECODE
REPORTSTO
REPORTSTO
JOBTITLE
JOBTITLE
1
EMPLOYEENUMBER
integer
2
LASTNAME
string
3
FIRSTNAME
string
4
EXTENSION
string
5
EMAIL
string
6
OFFICECODE
string
7
REPORTSTO
integer
8
JOBTITLE
string
Data Source
1
EMPLOYEENUMBER
EMPLOYEENUMBER
integer
4
2
LASTNAME
LASTNAME
string
12
3
FIRSTNAME
FIRSTNAME
string
12
4
EXTENSION
EXTENSION
string
12
5
EMAIL
EMAIL
string
12
6
OFFICECODE
OFFICECODE
string
12
7
REPORTSTO
REPORTSTO
integer
4
8
JOBTITLE
JOBTITLE
string
12
1.0
CUSTOMERNUMBER
1
4
10
0
Nullable
CUSTOMERNUMBER
CUSTOMERNUMBER
11
]]>
OFFICECODE
OFFICECODE
CITY
CITY
PHONE
PHONE
ADDRESSLINE1
ADDRESSLINE1
ADDRESSLINE2
ADDRESSLINE2
STATE
STATE
COUNTRY
COUNTRY
POSTALCODE
POSTALCODE
TERRITORY
TERRITORY
1
OFFICECODE
string
2
CITY
string
3
PHONE
string
4
ADDRESSLINE1
string
5
ADDRESSLINE2
string
6
STATE
string
7
COUNTRY
string
8
POSTALCODE
string
9
TERRITORY
string
Data Source
1
OFFICECODE
OFFICECODE
string
12
2
CITY
CITY
string
12
3
PHONE
PHONE
string
12
4
ADDRESSLINE1
ADDRESSLINE1
string
12
5
ADDRESSLINE2
ADDRESSLINE2
string
12
6
STATE
STATE
string
12
7
COUNTRY
COUNTRY
string
12
8
POSTALCODE
POSTALCODE
string
12
9
TERRITORY
TERRITORY
string
12
1.0
OFFICECODE
1
12
10
0
Nullable
OFFICECODE
OFFICECODE
10
CITY
2
12
50
0
Nullable
CITY
CITY
50
PHONE
3
12
50
0
Nullable
PHONE
PHONE
50
ADDRESSLINE1
4
12
50
0
Nullable
ADDRESSLINE1
ADDRESSLINE1
50
ADDRESSLINE2
5
12
50
0
Nullable
ADDRESSLINE2
ADDRESSLINE2
50
STATE
6
12
50
0
Nullable
STATE
STATE
50
COUNTRY
7
12
50
0
Nullable
COUNTRY
COUNTRY
50
POSTALCODE
8
12
15
0
Nullable
POSTALCODE
POSTALCODE
15
TERRITORY
9
12
10
0
Nullable
TERRITORY
TERRITORY
10
]]>
OFFICECODE
OFFICECODE
1
OFFICECODE
string
Data Source
1
OFFICECODE
OFFICECODE
string
12
1.0
OFFICECODE
1
12
10
0
Nullable
OFFICECODE
OFFICECODE
10
CITY
2
12
50
0
Nullable
CITY
CITY
50
PHONE
3
12
50
0
Nullable
PHONE
PHONE
50
ADDRESSLINE1
4
12
50
0
Nullable
ADDRESSLINE1
ADDRESSLINE1
50
ADDRESSLINE2
5
12
50
0
Nullable
ADDRESSLINE2
ADDRESSLINE2
50
STATE
6
12
50
0
Nullable
STATE
STATE
50
COUNTRY
7
12
50
0
Nullable
COUNTRY
COUNTRY
50
POSTALCODE
8
12
15
0
Nullable
POSTALCODE
POSTALCODE
15
TERRITORY
9
12
10
0
Nullable
TERRITORY
TERRITORY
10
]]>
0.25in
0.25in
0.25in
0.25in
html
new Date()]]>
100%
Employee
EMPLOYEENUMBER
EMPLOYEENUMBER
dataSetRow["EMPLOYEENUMBER"]
integer
LASTNAME
LASTNAME
dataSetRow["LASTNAME"]
string
FIRSTNAME
FIRSTNAME
dataSetRow["FIRSTNAME"]
string
EXTENSION
EXTENSION
dataSetRow["EXTENSION"]
string
EMAIL
EMAIL
dataSetRow["EMAIL"]
string
OFFICECODE
OFFICECODE
dataSetRow["OFFICECODE"]
string
REPORTSTO
REPORTSTO
dataSetRow["REPORTSTO"]
integer
JOBTITLE
JOBTITLE
dataSetRow["JOBTITLE"]
string
100%
EMPLOYEENUMBER
|
LASTNAME
|
FIRSTNAME
|
EXTENSION
|
EMAIL
|
OFFICECODE
bookmark-link
"_Tocmycode"+row["OFFICECODE"]
|
REPORTSTO
|
JOBTITLE
|
|
100%
Office
OFFICECODE
OFFICECODE
dataSetRow["OFFICECODE"]
string
CITY
CITY
dataSetRow["CITY"]
string
PHONE
PHONE
dataSetRow["PHONE"]
string
ADDRESSLINE1
ADDRESSLINE1
dataSetRow["ADDRESSLINE1"]
string
ADDRESSLINE2
ADDRESSLINE2
dataSetRow["ADDRESSLINE2"]
string
STATE
STATE
dataSetRow["STATE"]
string
COUNTRY
COUNTRY
dataSetRow["COUNTRY"]
string
POSTALCODE
POSTALCODE
dataSetRow["POSTALCODE"]
string
TERRITORY
TERRITORY
dataSetRow["TERRITORY"]
string
row["OFFICECODE"]
100%
row["OFFICECODE"]+"grid"
"_Tocmycode"+row["OFFICECODE"]
"mycode"+row["OFFICECODE"]
OFFICECODE
|
CITY
|
PHONE
|
ADDRESSLINE1
|
ADDRESSLINE2
|
STATE
|
COUNTRY
|
POSTALCODE
|
TERRITORY
|
|