Eclipse BIRT Designer Version 0.0.1 Build <20050405-1230> in Data Source 12 PHONE_12 13 COUNTRY_13 LongCountry row["LongCountry"] = row["COUNTRY"]; if (row["COUNTRY"] == "UK") row["LongCountry"] = "United Kingdom"; if (row["COUNTRY"] == "USA") row["LongCountry"] = "United States of America"; SELECT CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED, CLASSICMODELS.ORDERDETAILS.PRICEEACH, CLASSICMODELS.ORDERDETAILS.PRODUCTCODE, CLASSICMODELS.ORDERS.STATUS, CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME, CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME, CLASSICMODELS.CUSTOMERS.PHONE, CLASSICMODELS.CUSTOMERS.CITY, CLASSICMODELS.CUSTOMERS.COUNTRY, CLASSICMODELS.OFFICES.OFFICECODE, CLASSICMODELS.OFFICES.PHONE, CLASSICMODELS.OFFICES.COUNTRY, CLASSICMODELS.PRODUCTS.PRODUCTNAME, CLASSICMODELS.OFFICES.TERRITORY FROM (((CLASSICMODELS.ORDERDETAILS INNER JOIN CLASSICMODELS.ORDERS ON CLASSICMODELS.ORDERDETAILS.ORDERNUMBER=CLASSICMODELS.ORDERS.ORDERNUMBER) INNER JOIN CLASSICMODELS.CUSTOMERS ON CLASSICMODELS.ORDERS.CUSTOMERNUMBER=CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER) INNER JOIN CLASSICMODELS.EMPLOYEES ON CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER=CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER) INNER JOIN CLASSICMODELS.OFFICES ON CLASSICMODELS.EMPLOYEES.OFFICECODE=CLASSICMODELS.OFFICES.OFFICECODE, CLASSICMODELS.PRODUCTS WHERE CLASSICMODELS.PRODUCTS.PRODUCTCODE=CLASSICMODELS.ORDERDETAILS.PRODUCTCODE order by CLASSICMODELS.OFFICES.OFFICECODE 0.3in 0.2in 0.2in 0.2in 100% xx-large bold center 100% right 100%Data Set row["ProductCode"] asc false 4cm 6cm 2cm 2cm 3cm 3cm
6 1 #EAEAEA 100% 2.8in 3.125in top 1 1 "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 center middle 6 1 middle
customer none desc row["customerName"]
6 1 1cm 0.5cm center 80% #FFFFFF #FFFFFF #FFFFFF row["OFFICECODE"] #FFFFFF #FFFFFF row["COUNTRY"] + ": " + row["TERRITORY"] 4 1 #004080 Label #FFFFFF row["customerName"] Border Border Data html row["contactFirstName"] row["contactLastName"]]]> Border Border Data row["phone"] Border 3 1 Border Data html row["city"], row["country"]]]> middle 1 1 Border #000000 none thin #000000 none thin #004080 solid medium 0.5cm 1 1 #004080 solid medium 0.5cm #004080 solid medium 0.5cm #004080 solid medium 0.5cm #004080 solid medium 0.5cm Border #000000 none thin #000000 none thin #004080 solid medium 0.5cm
Border #000000 none thin #000000 none thin #000000 none thin Border #000000 none thin #000000 none thin #000000 none thin Border #000000 none thin #000000 none thin #000000 none thin 0cm Border #000000 none thin #000000 none thin #000000 none thin 0in Data bold Total.sum(row["quantityOrdered"]) Border #000000 none thin #000000 none thin #000000 none thin 0cm Border #000000 none thin #000000 none thin #000000 none thin 0cm Data bold Total.sum(row["priceEach"]*row["quantityOrdered"])
1 1 Border #000000 none thin #000000 none thin #000000 none thin 0.1cm Data row["ProductCode"] 1 1 #000000 none thin #000000 none thin #000000 none thin Data row["PRODUCTNAME"] Data row["priceEach"] Data row["quantityOrdered"] Data row["status"] Border #000000 none thin #000000 none thin #000000 none thin Data row["priceEach"]*row["quantityOrdered"]