Eclipse BIRT Designer Version 0.0.1 Build <20050405-1230> in ProductCode S18_1749 Product Code Please specify the product code string false Unformatted text-box "S18_1749" Data Source ProductCode string 1 "S18_1749" true true false SELECT distinct CLASSICMODELS.PRODUCTS.PRODUCTCODE, CLASSICMODELS.PRODUCTS.PRODUCTNAME, CLASSICMODELS.PRODUCTS.PRODUCTLINE, CLASSICMODELS.PRODUCTS.PRODUCTVENDOR, CLASSICMODELS.PRODUCTS.BUYPRICE, CLASSICMODELS.PRODUCTS.MSRP, CLASSICMODELS.PRODUCTS.QUANTITYINSTOCK, CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED FROM CLASSICMODELS.PRODUCTS,CLASSICMODELS.ORDERDETAILS WHERE CLASSICMODELS.PRODUCTS.PRODUCTCODE=CLASSICMODELS.ORDERDETAILS.PRODUCTCODE and CLASSICMODELS.ORDERDETAILS.PRODUCTCODE=? 100% xx-large bold center 100% html new Date()]]> right 100%dSet ProductCode params["ProductCode"] row["productCode"] asc 13% 25% 20% 10% 10% 10% 12%

7 1 100% center 72px 105px "http://download.eclipse.org/birt/downloads/examples/images/ClassicLogo.jpg" center Georgia xx-large bold #FF8040 Classic Models Corporation center 72px 105px "http://download.eclipse.org/birt/downloads/examples/images/ClassicLogo.jpg"

group none asc row["productCode"]

#000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Label Product Code #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Label Product Name #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Label Product Vendor #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Label Qty in Stock #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Label Price Each #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Label MSRP #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Label Orders #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Data row["productCode"] #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Data row["productName"] #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Data row["productVendor"] #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Data row["quantityInStock"] #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Data row["buyPrice"] #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Data row["MSRP"] #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Data Total.sum(row["quantityOrdered"])