Paul Clenahan Eclipse BIRT Designer Version 1.0.0 Build <20050601-0809> in

Classic Models Sales Invoice Report

OrderNumber 10201

Order Naumber

Order number for the invoice

decimal false text-box 10100 General Number General Number

OrderNumber integer 1 10100 true true false

1 OFFICE_CITY string 2 LASTNAME string 3 FIRSTNAME string 4 CUSTOMERNUMBER integer 5 CUSTOMERNAME string 6 CONTACTLASTNAME string 7 CONTACTFIRSTNAME string 8 ADDRESSLINE1 string 9 ADDRESSLINE2 string 10 CITY string 11 STATE string 12 POSTALCODE string 13 COUNTRY string 14 ORDERNUMBER integer 15 ORDERDATE date-time 16 SHIPPEDDATE date-time 17 PRODUCTCODE string 18 QUANTITYORDERED integer 19 PRICEEACH float 20 PRODUCTNAME string 21 MSRP float

Classic Models SELECT CLASSICMODELS.OFFICES.CITY AS "OFFICE_CITY", CLASSICMODELS.EMPLOYEES.LASTNAME, CLASSICMODELS.EMPLOYEES.FIRSTNAME, CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER, CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME, CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME, CLASSICMODELS.CUSTOMERS.ADDRESSLINE1, CLASSICMODELS.CUSTOMERS.ADDRESSLINE2, CLASSICMODELS.CUSTOMERS.CITY, CLASSICMODELS.CUSTOMERS.STATE, CLASSICMODELS.CUSTOMERS.POSTALCODE, CLASSICMODELS.CUSTOMERS.COUNTRY, CLASSICMODELS.ORDERS.ORDERNUMBER, CLASSICMODELS.ORDERS.ORDERDATE, CLASSICMODELS.ORDERS.SHIPPEDDATE, CLASSICMODELS.ORDERDETAILS.PRODUCTCODE, CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED, CLASSICMODELS.ORDERDETAILS.PRICEEACH, CLASSICMODELS.PRODUCTS.PRODUCTNAME, CLASSICMODELS.PRODUCTS.MSRP FROM CLASSICMODELS.OFFICES, CLASSICMODELS.EMPLOYEES, CLASSICMODELS.CUSTOMERS, CLASSICMODELS.ORDERS, CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.PRODUCTS WHERE CLASSICMODELS.OFFICES.OFFICECODE = CLASSICMODELS.EMPLOYEES.OFFICECODE AND CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER = CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER AND CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER = CLASSICMODELS.ORDERS.CUSTOMERNUMBER AND CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBER AND CLASSICMODELS.ORDERDETAILS.PRODUCTCODE = CLASSICMODELS.PRODUCTS.PRODUCTCODE AND CLASSICMODELS.ORDERS.ORDERNUMBER = ? ORDER BY CLASSICMODELS.ORDERS.ORDERNUMBER

sans-serif 10pt html

new Date()]]>

100% 2.8in 3.2in BackgroundLightGray BackgroundLightGray #808080 solid thin #808080 solid thin #808080 solid thin #808080 solid thin C:\Documents and Settings\pclenahan\My Documents\ClassicModels\logos\Classic-Models-Full-M.jpg BackgroundLightGray middle sans-serif 20pt bold #000080

Classic Models, Inc.

sans-serif html

San Francisco, CA 94107

]]>

sans-serif 18pt bold

Sales Invoice

0.25in 100%Invoice Data

OrderNumber params["OrderNumber"]

PRODUCTCODE dataSetRow["PRODUCTCODE"] PRODUCTNAME dataSetRow["PRODUCTNAME"] QUANTITYORDERED dataSetRow["QUANTITYORDERED"] MSRP dataSetRow["MSRP"] PRICEEACH dataSetRow["PRICEEACH"] (row["MSRP"] - row["PRICEEACH"]) / row["MSRP"] (row["MSRP"] - row["PRICEEACH"]) / row["MSRP"] row["QUANTITYORDERED"] * row["PRICEEACH"] row["QUANTITYORDERED"] * row["PRICEEACH"] ORDERNUMBER dataSetRow["ORDERNUMBER"] Order Group CUSTOMERNAME dataSetRow["CUSTOMERNAME"] Order Group CONTACTFIRSTNAME dataSetRow["CONTACTFIRSTNAME"] Order Group CONTACTLASTNAME dataSetRow["CONTACTLASTNAME"] Order Group row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"] row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"] Order Group ADDRESSLINE1 dataSetRow["ADDRESSLINE1"] Order Group ADDRESSLINE2 dataSetRow["ADDRESSLINE2"] Order Group CITY dataSetRow["CITY"] Order Group STATE dataSetRow["STATE"] Order Group POSTALCODE dataSetRow["POSTALCODE"] Order Group (row["CITY"] + ", " + row["STATE"] + " " + row["POSTALCODE"]).replace("null, ", "").replace("null ", "").replace("null", "") (row["CITY"] + ", " + row["STATE"] + " " + row["POSTALCODE"]).replace("null, ", "").replace("null ", "").replace("null", "") Order Group COUNTRY dataSetRow["COUNTRY"] Order Group CUSTOMERNUMBER dataSetRow["CUSTOMERNUMBER"] Order Group ORDERDATE dataSetRow["ORDERDATE"] Order Group SHIPPEDDATE dataSetRow["SHIPPEDDATE"] Order Group OFFICE_CITY dataSetRow["OFFICE_CITY"] Order Group FIRSTNAME dataSetRow["FIRSTNAME"] Order Group LASTNAME dataSetRow["LASTNAME"] Order Group row["FIRSTNAME"] + " " + row["LASTNAME"] row["FIRSTNAME"] + " " + row["LASTNAME"] Order Group QUANTITYORDERED_1 dataSetRow["QUANTITYORDERED"] Order Group PRICEEACH_1 dataSetRow["PRICEEACH"] Order Group Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH"]) Total.sum(row["QUANTITYORDERED"]*row["PRICEEACH"]) Order Group

Order Group none asc row["ORDERNUMBER"]

7 1 100% 2.343in 0.25in 3.312in BackgroundBlue sans-serif large #FFFFFF

Customer Details

BackgroundBlue sans-serif large #FFFFFF

Order Details

BackgroundLightGray top sans-serif bold CUSTOMERNAME sans-serif bold row["CONTACTFIRSTNAME"] + " " + row["CONTACTLASTNAME"] sans-serif bold ADDRESSLINE1 sans-serif bold ADDRESSLINE2 sans-serif bold (row["CITY"] + ", " + row["STATE"] + " " + row["POSTALCODE"]).replace("null, ", "").replace("null ", "").replace("null", "") sans-serif bold COUNTRY BackgroundLightGray 100% sans-serif

Customer Number:

sans-serif bold CUSTOMERNUMBER sans-serif

Order Number:

sans-serif bold ORDERNUMBER sans-serif

Order Date:

sans-serif bold ORDERDATE sans-serif

Ship Date:

sans-serif bold SHIPPEDDATE sans-serif

Office:

sans-serif bold OFFICE_CITY sans-serif

Sales Representative:

sans-serif bold row["FIRSTNAME"] + " " + row["LASTNAME"] 0.25in BackgroundYellow BackgroundYellow #808080 solid thin #808080 solid thin #808080 solid thin #808080 solid thin 3pt 3pt 3pt 3pt sans-serif bold

Code

BackgroundYellow #808080 solid thin #808080 solid thin #808080 solid thin #808080 solid thin 3pt 3pt 3pt 3pt sans-serif bold

Description