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 12 2 ORDERNUMBER integer 4 3 ORDERDATE date-time 91 4 STATUS string 12 5 QUANTITYORDERED integer 4 6 PRICEEACH float 8 1 CUSTOMERNAME string 2 ORDERNUMBER integer 3 ORDERDATE date-time 4 STATUS string 5 QUANTITYORDERED integer 6 PRICEEACH float srcClassicModels 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 12 2 CONTACTLASTNAME string 12 3 CONTACTFIRSTNAME string 12 4 PHONE string 12 5 ADDRESSLINE1 string 12 6 ADDRESSLINE2 string 12 7 CITY string 12 8 STATE string 12 9 POSTALCODE string 12 10 COUNTRY string 12 11 CREDITLIMIT float 8 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 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 1 CONTACTLASTNAME string 12 2 CONTACTFIRSTNAME string 12 3 PHONE string 12 4 CUSTOMERNAME string 12 5 CUSTOMERNUMBER integer 4 6 CUSTOMERTOTAL float 8 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 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 customerratio 1 CUSTOMERNAME string 12 2 CUSTOMERNUMBER integer 4 3 CREDITLIMIT float 8 4 ORDERTOTALS float 8 5 PAIDTOTALS float 8 Outstanding row["ORDERTOTALS"]-row["PAIDTOTALS"] float 1 CUSTOMERNAME string 2 CUSTOMERNUMBER integer 3 CREDITLIMIT float 4 ORDERTOTALS float 5 PAIDTOTALS float 6 Outstanding float srcClassicModels select CUSTOMERS.CUSTOMERNAME, CUSTOMERS.CUSTOMERNUMBER,CLASSICMODELS.CUSTOMERS.CREDITLIMIT, ordersums.OrderTotals, paymentsums.PaidTotals from CUSTOMERS, ( select ORDERS.CUSTOMERNUMBER, sum(ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) as OrderTotals from ORDERS, ORDERDETAILS where ORDERDETAILS.ORDERNUMBER = ORDERS.ORDERNUMBER group by ORDERS.CUSTOMERNUMBER) ordersums, ( select CUSTOMERS.CUSTOMERNUMBER, sum(PAYMENTS.AMOUNT) as PaidTotals from CUSTOMERS, PAYMENTS where PAYMENTS.CUSTOMERNUMBER = CUSTOMERS.CUSTOMERNUMBER group by CUSTOMERS.CUSTOMERNUMBER) paymentsums where CUSTOMERS.CUSTOMERNUMBER = ordersums.CUSTOMERNUMBER and CUSTOMERS.CUSTOMERNUMBER = paymentsums.CUSTOMERNUMBER 100% center middle 3.885in 6.114in customerratio CUSTOMERNAME dataSetRow["CUSTOMERNAME"] string CUSTOMERNUMBER dataSetRow["CUSTOMERNUMBER"] integer CREDITLIMIT dataSetRow["CREDITLIMIT"] float ORDERTOTALS dataSetRow["ORDERTOTALS"] float PAIDTOTALS dataSetRow["PAIDTOTALS"] float Outstanding dataSetRow["Outstanding"] float Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true Outstanding Ratio 16.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Vertical Top_Bottom 1 255 0 0 0 true Right Series Above 0.0 0.0 440.25 279.75 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 255 255 255 255 true Two_Dimensional_With_Depth Points 10.0 A, B, C 5,4,12 0 5,4,12 1 Text Below Linear Left 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 true row["Outstanding"] Orthogonal_Value , Inside false onclick URL_Redirect <structure name="action"> <property name="linkType">bookmark-link</property> <expression name="targetBookmark">row["CUSTOMERNAME"]</expression> </structure> true Rectangle false 2 Text Sum Vertical 1 255 0 0 0 true 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 false Across 1 255 196 196 196 true 1 255 225 225 225 false Across 1 255 225 225 225 false 250000.0 5 Min 0.0 true false Linear Right 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 true row["CREDITLIMIT"] Orthogonal_Value , Above false Box 4 true 1 255 0 0 0 true false 2 Text Sum Vertical 1 255 0 0 0 true 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 false Right 1 255 196 196 196 false Across 1 255 196 196 196 true 1 255 225 225 225 false Across 1 255 225 225 225 false 250000.0 5 Max false false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["CUSTOMERNAME"] Orthogonal_Value , Outside false false 2 Text Sum Horizontal 1 255 0 0 0 true -45.0 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Below 1 255 196 196 196 false Across 1 255 196 196 196 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true true false Vertical 50.0 ]]> SVG top-n row["Outstanding"] 5 sans-serif large bold #004080 center Customer Orders #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

Customer Order Number Date Status center Quantity right Price right Total

grpCustomerName none asc row["CUSTOMERNAME"] row["CUSTOMERNAME"] + ": $(" + row["CUSTOMERTOTAL"].toFixed(2) + ")USD" true false auto auto

group1 row["CUSTOMERNAME"] CUSTOMERNAME bookmark-link row["CUSTOMERNAME"]

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"]

Short Date Short Date ORDERDATE none STATUS center QUANTITYORDERED Currency $#,##0.00;$(#,##0.00) right PRICEEACH Currency $#,##0.00;$(#,##0.00) right TOTALSALE sans-serif large bold #004080 center always Customer Listing #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

Customer Contact Address right Credit Limit

#004080 solid medium CUSTOMERNAME #004080 solid medium CONTACTLASTNAME #004080 solid medium ADDRESSLINE1 #004080 solid medium Currency $#,##0.00;$(#,##0.00) right CREDITLIMIT