Eclipse BIRT Designer Version 1.0.1 Build <20050729-0746>
in
EmployeesDataSource
select CLASSICMODELS.EMPLOYEES.FIRSTNAME,CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER,
CLASSICMODELS.EMPLOYEES.LASTNAME,
CLASSICMODELS.EMPLOYEES.OFFICECODE,
CLASSICMODELS.EMPLOYEES.REPORTSTO,
CLASSICMODELS.EMPLOYEES.JOBTITLE
from CLASSICMODELS.EMPLOYEES
EmployeesDataSource
EmpID
integer
1
1002
true
true
false
select CLASSICMODELS.EMPLOYEES.FIRSTNAME,
CLASSICMODELS.EMPLOYEES.LASTNAME,
CLASSICMODELS.EMPLOYEES.JOBTITLE
from CLASSICMODELS.EMPLOYEES
where CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER = ?
html
new Date()]]>
#EAEAEA
100%
2.8in
3.125in
top
|
1
1
#808080
solid
thin
#808080
solid
thin
#808080
solid
thin
#808080
solid
thin
"http://download.eclipse.org/birt/downloads/examples/images/ClassicLogo.jpg"
|
middle
sans-serif
10pt
html
701 Gateway Boulevard,
San Francisco, CA 94107
]]>
|
0.25in
#FFFFFF
top
|
middle
|
100%
top
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
100%
AllEmployeesDataSet
is-not-null
row["REPORTSTO"]
row["OFFICECODE"]
"1"
|
3
1
#FFFFFF
sans-serif
x-large
bold
#0080FF
#000000
solid
thin
center
"Office Code: " + row["OFFICECODE"]
|
Manager
none
asc
row["REPORTSTO"]
3
1
#C0C0C0
#000000
solid
thin
100%
OneEmployeeDataSet
EmpID
row["REPORTSTO"]
|
sans-serif
bold
row["FIRSTNAME"] + " " + row["LASTNAME"]
|
sans-serif
bold
right
row["JOBTITLE"]
|
|
|
|
sans-serif
1cm
left
row["FIRSTNAME"] + " " + row["LASTNAME"]
|
sans-serif
right
row["JOBTITLE"]
|
|
top
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
#000000
solid
thin
100%
AllEmployeesDataSet
is-not-null
row["REPORTSTO"]
row["OFFICECODE"]
"4"
|
3
1
#FFFFFF
sans-serif
x-large
bold
#0080FF
#000000
solid
thin
center
"Office Code: " + row["OFFICECODE"]
|
Manager
none
asc
row["REPORTSTO"]
3
1
#C0C0C0
#000000
solid
thin
100%
OneEmployeeDataSet
EmpID
row["REPORTSTO"]
|
sans-serif
bold
row["FIRSTNAME"] + " " + row["LASTNAME"]
|
sans-serif
bold
right
row["JOBTITLE"]
|
|
|
|
sans-serif
1cm
row["FIRSTNAME"] + " " + row["LASTNAME"]
|
sans-serif
right
row["JOBTITLE"]
|
|