Eclipse BIRT Designer Version 2.1.0.N20060628-1351 Build <20060628-1537> in Copyright (c) 2006 <<Your Company Name here>> org.eclipse.birt.report.data.oda.sampledb.Driver jdbc:classicmodels:sampledb ClassicModels 1 CUSTOMERNAME string 2 ORDERNUMBER integer 3 ORDERDATE date-time 4 STATUS string 5 QUANTITYORDERED integer 6 PRICEEACH float srcClassicModels 1 CUSTOMERNAME CUSTOMERNAME string 12 2 ORDERNUMBER ORDERNUMBER integer 4 3 ORDERDATE ORDERDATE date-time 91 4 STATUS STATUS string 12 5 QUANTITYORDERED QUANTITYORDERED integer 4 6 PRICEEACH PRICEEACH float 8 select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.ORDERS.ORDERNUMBER, CLASSICMODELS.ORDERS.ORDERDATE, CLASSICMODELS.ORDERS.STATUS, CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED, CLASSICMODELS.ORDERDETAILS.PRICEEACH from CLASSICMODELS.CUSTOMERS, CLASSICMODELS.ORDERS, CLASSICMODELS.ORDERDETAILS where CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER = CLASSICMODELS.ORDERS.CUSTOMERNUMBER and CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBER 1 CUSTOMERNAME string 2 CONTACTLASTNAME string 3 CONTACTFIRSTNAME string 4 PHONE string 5 ADDRESSLINE1 string 6 ADDRESSLINE2 string 7 CITY string 8 STATE string 9 POSTALCODE string 10 COUNTRY string 11 CREDITLIMIT float srcClassicModels 1 CUSTOMERNAME CUSTOMERNAME string 12 2 CONTACTLASTNAME CONTACTLASTNAME string 12 3 CONTACTFIRSTNAME CONTACTFIRSTNAME string 12 4 PHONE PHONE string 12 5 ADDRESSLINE1 ADDRESSLINE1 string 12 6 ADDRESSLINE2 ADDRESSLINE2 string 12 7 CITY CITY string 12 8 STATE STATE string 12 9 POSTALCODE POSTALCODE string 12 10 COUNTRY COUNTRY string 12 11 CREDITLIMIT CREDITLIMIT float 8 select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME, CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME, CLASSICMODELS.CUSTOMERS.PHONE, CLASSICMODELS.CUSTOMERS.ADDRESSLINE1, CLASSICMODELS.CUSTOMERS.ADDRESSLINE2, CLASSICMODELS.CUSTOMERS.CITY, CLASSICMODELS.CUSTOMERS.STATE, CLASSICMODELS.CUSTOMERS.POSTALCODE, CLASSICMODELS.CUSTOMERS.COUNTRY, CLASSICMODELS.CUSTOMERS.CREDITLIMIT from CLASSICMODELS.CUSTOMERS percentoftotal (Total.percentSum(row["CUSTOMERTOTAL"])*100).toFixed(2) float 1 CONTACTLASTNAME string 2 CONTACTFIRSTNAME string 3 PHONE string 4 CUSTOMERNAME string 5 CUSTOMERNUMBER integer 6 CUSTOMERTOTAL float 7 percentoftotal float srcClassicModels 1 CONTACTLASTNAME CONTACTLASTNAME string 12 2 CONTACTFIRSTNAME CONTACTFIRSTNAME string 12 3 PHONE PHONE string 12 4 CUSTOMERNAME CUSTOMERNAME string 12 5 CUSTOMERNUMBER CUSTOMERNUMBER integer 4 6 CUSTOMERTOTAL CUSTOMERTOTAL float 8 select CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME, CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME, CLASSICMODELS.CUSTOMERS.PHONE, CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER, sum(ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) as CUSTOMERTOTAL from CUSTOMERS, ORDERS, ORDERDETAILS where CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER and ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER group by CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER, CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME, CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME,CLASSICMODELS.CUSTOMERS.PHONE order by CUSTOMERTOTAL 100% center middle #004080solidmedium#004080solidmedium#004080solidmedium#004080solidmedium100%setOrders CUSTOMERNAME dataSetRow["CUSTOMERNAME"] string ORDERDATE dataSetRow["ORDERDATE"] date-time STATUS dataSetRow["STATUS"] string QUANTITYORDERED dataSetRow["QUANTITYORDERED"] integer PRICEEACH dataSetRow["PRICEEACH"] float TOTALSALE dataSetRow["QUANTITYORDERED"] * dataSetRow["PRICEEACH"] float ORDERNUMBER dataSetRow["ORDERNUMBER"] integer ORDERTOTAL Total.sum(row["TOTALSALE"]) float grpOrderNumber CUSTOMERTOTAL Total.sum(row["TOTALSALE"]) float grpCustomerName
grpCustomerName none asc row["CUSTOMERNAME"] row["CUSTOMERNAME"] + ": $(" + row["CUSTOMERTOTAL"].toFixed(2) + ")USD" true false auto auto
group1 row["CUSTOMERNAME"] CUSTOMERNAME bookmark-link row["CUSTOMERNAME"]
group1 #EAF3F4 solid thin #EAF3F4 solid thin #EAF3F4 solid thin #EAF3F4 solid thin 2 1 #EAF3F4 solid thin #EAF3F4 solid thin Currency $#,##0.00;$(#,##0.00) right CUSTOMERTOTAL
grpOrderNumber none asc row["ORDERNUMBER"] "Order Number: " + row["ORDERNUMBER"] + "\n$(" + row["ORDERTOTAL"].toFixed(2) + ")USD" true false auto auto
group2 ORDERNUMBER html drill-through detail.rptdesign _blank report-design rptParamOrderNumber row["ORDERNUMBER"]
group2 #86BAC1 solid thin #86BAC1 solid thin #86BAC1 solid thin #86BAC1 solid thin 2 1 #86BAC1 solid thin #86BAC1 solid thin Currency $#,##0.00;$(#,##0.00) right ORDERTOTAL
Short Date Short Date ORDERDATE none STATUS center QUANTITYORDERED Currency $#,##0.00;$(#,##0.00) right PRICEEACH Currency $#,##0.00;$(#,##0.00) right TOTALSALE
#004080solidmedium#004080solidmedium#004080solidmedium#004080solidmediumauto100%setCustomerList CUSTOMERNAME dataSetRow["CUSTOMERNAME"] string CONTACTLASTNAME dataSetRow["CONTACTLASTNAME"] + ", " + dataSetRow["CONTACTFIRSTNAME"] string CONTACTFIRSTNAME dataSetRow["CONTACTFIRSTNAME"] string PHONE dataSetRow["PHONE"] string ADDRESSLINE1 dataSetRow["ADDRESSLINE1"] + "\n" + dataSetRow["CITY"] + ", " + dataSetRow["STATE"] + " " + dataSetRow["POSTALCODE"] + "\n" + dataSetRow["COUNTRY"] string ADDRESSLINE2 dataSetRow["ADDRESSLINE2"] string CITY dataSetRow["CITY"] string STATE dataSetRow["STATE"] string POSTALCODE dataSetRow["POSTALCODE"] string COUNTRY dataSetRow["COUNTRY"] string CREDITLIMIT dataSetRow["CREDITLIMIT"] float
#004080 solid medium CUSTOMERNAME #004080 solid medium CONTACTLASTNAME #004080 solid medium ADDRESSLINE1 #004080 solid medium Currency $#,##0.00;$(#,##0.00) right CREDITLIMIT