Eclipse BIRT Designer Version 1.0.1 Build <20050729-0746> in Classic Models SalesRep row["LASTNAME"] + ", " + row["FIRSTNAME"] select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.CUSTOMERS.CITY, CLASSICMODELS.CUSTOMERS.COUNTRY, CLASSICMODELS.EMPLOYEES.LASTNAME, CLASSICMODELS.EMPLOYEES.FIRSTNAME from CLASSICMODELS.CUSTOMERS, CLASSICMODELS.EMPLOYEES WHERE CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER = CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER and CLASSICMODELS.CUSTOMERS.CREDITLIMIT > 80000 html new Date()]]> 100% 2.8in 3.2in sans-serif #808080 solid thin #808080 solid thin #808080 solid thin #808080 solid thin "http://download1.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 18pt bold Customers List 0.25in 100%Customer Listing

#FFFF80 Arial 0.1pt 0.1pt 0.1pt 0.1pt Customer Name #FFFF80 Arial 0.1pt 0.1pt 0.1pt 0.1pt Customer City #FFFF80 Arial 0.1pt 0.1pt 0.1pt 0.1pt Sales Rep

GroupByCountry none desc row["COUNTRY"]

3 1 #C0C0C0 Arial "Customers in the " + row["COUNTRY"] + ": " + Total.countDistinct(row["CUSTOMERNAME"])

Arial row["CUSTOMERNAME"] Arial row["CITY"] html row["LASTNAME"]row["FIRSTNAME"]]]>