Eclipse BIRT Designer Version 1.0.0 Build <20050601-0809> in LoSpendThresh 100,000 HiSpendThresh 1,000,000 MasterDetailDS select CLASSICMODELS.PAYMENTS.CUSTOMERNUMBER, sum(CLASSICMODELS.PAYMENTS.AMOUNT) from CLASSICMODELS.PAYMENTS group by CLASSICMODELS.PAYMENTS.CUSTOMERNUMBER MasterDetailDS CustID integer 1 141 true true false select CLASSICMODELS.CUSTOMERS.*, CLASSICMODELS.EMPLOYEES.FIRSTNAME || ' ' || CLASSICMODELS.EMPLOYEES.LASTNAME from CLASSICMODELS.CUSTOMERS, CLASSICMODELS.EMPLOYEES where CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER = CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER AND CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER = ? Arial bold html new Date()]]> 100% 2.8in 3.2in "http://download.eclipse.org/birt/downloads/examples/images/ClassicLogo.jpg" middle sans-serif 20pt bold #000080 Classic Models, Inc. sans-serif html San Francisco, CA 94107

]]> sans-serif 14pt bold Customer Purchase Report 0.25in 2.01in6.052inBigSpenders row["2"] desc 3.906in 2.145in

#FFFF80 Arial large bold Customer ID #FFFF80 Arial large bold Amount Spent

none #000000 solid thin Arial bold cid = row["CUSTOMERNUMBER"]; row["CUSTOMERNUMBER"]; none #000000 solid thin Arial bold #008000 Currency $#,##0 left Math.round(row["2"]/100)*100 0.02in #000000 #FFFFFF none none #FFFFFF 2 1 none Arial Narrowsmalljustifytopautoautoinherit100%Customer Detail CustID cid 0.1in row["CUSTOMERNAME"] + ", " + row["ADDRESSLINE1"] 0.1in row["ADDRESSLINE2"] 0.1in 0in if (row["STATE"]) { row["CITY"] + ", " + row["STATE"] + " - " + row["POSTALCODE"]; } else { row["CITY"] + ", " + row["POSTALCODE"]; } 0.1in row["COUNTRY"] 0.1in Custom Custom (@@@)@@@-@@@@ row["PHONE"] #FFFFFF 2 1 none