Eclipse BIRT Designer Version 2.1.0.qualifier Build <@BUILD@>
in
Copyright (c) 2006 <<Innovent Solutions, Inc.>>
Data Source
org.eclipse.birt.report.data.oda.sampledb.Driver
jdbc:classicmodels:sampledb
ClassicModels
Data Set
1
CUSTOMERNUMBER
integer
4
2
CUSTOMERNAME
string
12
3
CONTACTLASTNAME
string
12
4
CONTACTFIRSTNAME
string
12
5
PHONE
string
12
6
ADDRESSLINE1
string
12
7
ADDRESSLINE2
string
12
8
CITY
string
12
9
STATE
string
12
10
POSTALCODE
string
12
11
COUNTRY
string
12
12
SALESREPEMPLOYEENUMBER
integer
4
13
CREDITLIMIT
float
8
1
CUSTOMERNUMBER
integer
2
CUSTOMERNAME
string
3
CONTACTLASTNAME
string
4
CONTACTFIRSTNAME
string
5
PHONE
string
6
ADDRESSLINE1
string
7
ADDRESSLINE2
string
8
CITY
string
9
STATE
string
10
POSTALCODE
string
11
COUNTRY
string
12
SALESREPEMPLOYEENUMBER
integer
13
CREDITLIMIT
float
Data Source
0
select *
from CLASSICMODELS.CUSTOMERS
where creditlimit > 0
html
new Date()]]>
100%
Data Set
actualSum
Total.sum(row["CREDITLIMIT"])
decimal
CREDITLIMIT
dataSetRow["CREDITLIMIT"]
float
by1
Total.OptimisticSum(row["CREDITLIMIT"],1)
decimal
by10
Total.OptimisticSum(row["CREDITLIMIT"],10)
decimal
by100
Total.OptimisticSum(row["CREDITLIMIT"],100)
by1000
Total.OptimisticSum(row["CREDITLIMIT"],1000)
100%
#C0C0C0
|
|
|
|
|
|
NewStyle
#C0C0C0
|
#C0C0C0
bold
black
center
actualSum
|
#C0C0C0
bold
black
center
by1
|
#C0C0C0
bold
black
center
by10
|
#C0C0C0
bold
black
center
by100
|
#C0C0C0
bold
black
center
by1000
|
|
|
CREDITLIMIT
|