Eclipse BIRT Designer Version 0.0.1 Build <20050405-1230> in valid string true com.mysql.jdbc.Driver jdbc:mysql://localhost/classicmodels root YWN0dWF0ZQ== Classic Models productLine any if-realized auto Product Line SELECT productLine, SUM( priceEach*quantityOrdered ) AS 'TotalRevenue' FROM orderdetails, products WHERE orderdetails.productCode = products.productCode GROUP BY products.productLine; Classic Models SELECT productName, SUM( priceEach*quantityOrdered ) AS 'TotalRevenue' FROM orderdetails, products WHERE orderdetails.productCode = products.productCode GROUP BY products.productName; 100% html new Date()]]> right #EAEAEA 100% 2.8in 3.125in top 1 1 #808080 solid thin #808080 solid thin #808080 solid thin #808080 solid thin "http://download.eclipse.org/birt/downloads/examples/images/ClassicLogo.jpg" middle sans-serif 18pt bold #004080 Classic Models, Inc. sans-serif 10pt html 701 Gateway Boulevard,
San Francisco, CA 94107

]]> sans-serif 18pt bold Top Selling Products 0.25in #FFFFFF top middle 100% 0.25in 0.1in BackgroundBlueGray BackgroundBlueGray sans-serif x-large bold Products in Revenue Generating Order 0.25in 100%Sales by Product row["TotalRevenue"] desc 2.541in 3.354in

BackgroundLightYellow BackgroundLightYellow TableHeaderText Product Name BackgroundLightYellow TableHeaderText Total Revenue

BackgroundLightGray BackgroundLightGray TableBodyText row["productName"] BackgroundLightGray TableBodyText Currency $#,##0.00 row["TotalRevenue"]