Eclipse BIRT Designer Version 2.1.1.v20060922-1058 Build <20060926-0959> in Copyright (c) 2006 <<Your Company Name here>> multiple dynamic integer true false list-box customers row["CUSTOMERNUMBER"] row["CUSTOMERNAME"] Unformatted dynamic integer false true false list-box orders row["ORDERNUMBER"] row["ORDERNUMBER"] Unformatted org.eclipse.birt.report.data.oda.sampledb.Driver jdbc:classicmodels:sampledb ClassicModels 1 CUSTOMERNAME string 2 CUSTOMERNUMBER integer Data Source 1 CUSTOMERNAME CUSTOMERNAME string 12 2 CUSTOMERNUMBER CUSTOMERNUMBER integer 4 select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER from CLASSICMODELS.CUSTOMERS 1.0 CUSTOMERNAME 1 12 50 0 Nullable CUSTOMERNAME 50 CUSTOMERNUMBER 2 4 10 0 Nullable CUSTOMERNUMBER 11 CUSTOMERNUMBER 1 4 ]]> 1 ORDERNUMBER integer 2 ORDERDATE date-time 3 REQUIREDDATE date-time 4 SHIPPEDDATE date-time 5 STATUS string 6 COMMENTS string 7 CUSTOMERNUMBER integer Data Source param1 customer integer 4 1 true true 1 ORDERNUMBER ORDERNUMBER integer 4 2 ORDERDATE ORDERDATE date-time 91 3 REQUIREDDATE REQUIREDDATE date-time 91 4 SHIPPEDDATE SHIPPEDDATE date-time 91 5 STATUS STATUS string 12 6 COMMENTS COMMENTS string 12 7 CUSTOMERNUMBER CUSTOMERNUMBER integer 4 select * from CLASSICMODELS.ORDERS where CLASSICMODELS.ORDERS.CUSTOMERNUMBER = ? 1.0 In 1 4 10 0 Unknown true false customers org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet Data Source org.eclipse.birt.report.data.oda.jdbc odaDriverClass org.eclipse.birt.report.data.oda.sampledb.Driver odaURL jdbc:classicmodels:sampledb odaDataSource odaUser ClassicModels odaPassword odaJndiName select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER from CLASSICMODELS.CUSTOMERS queryTimeOut CUSTOMERNAME 1 12 CUSTOMERNUMBER 2 4 true row["CUSTOMERNUMBER"] row["CUSTOMERNAME"] SelectableListWithTextField ORDERNUMBER 1 4 ORDERDATE 2 91 REQUIREDDATE 3 91 SHIPPEDDATE 4 91 STATUS 5 12 COMMENTS 6 12 CUSTOMERNUMBER 7 4 ]]> 1 ORDERNUMBER integer 2 PRODUCTCODE string 3 QUANTITYORDERED integer 4 PRICEEACH float 5 ORDERLINENUMBER integer Data Source param1 order integer 4 1 true true 1 ORDERNUMBER ORDERNUMBER integer 4 2 PRODUCTCODE PRODUCTCODE string 12 3 QUANTITYORDERED QUANTITYORDERED integer 4 4 PRICEEACH PRICEEACH float 8 5 ORDERLINENUMBER ORDERLINENUMBER integer 5 select * from CLASSICMODELS.ORDERDETAILS where CLASSICMODELS.ORDERDETAILS.ORDERNUMBER = ? 1.0 In 1 4 10 0 Unknown true false orders org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet Data Source org.eclipse.birt.report.data.oda.jdbc odaDriverClass org.eclipse.birt.report.data.oda.sampledb.Driver odaURL jdbc:classicmodels:sampledb odaDataSource odaUser ClassicModels odaPassword odaJndiName select * from CLASSICMODELS.ORDERS where CLASSICMODELS.ORDERS.CUSTOMERNUMBER = ? queryTimeOut ORDERNUMBER 1 4 ORDERDATE 2 91 REQUIREDDATE 3 91 SHIPPEDDATE 4 91 STATUS 5 12 COMMENTS 6 12 CUSTOMERNUMBER 7 4 In 1 4 10 0 Unknown true false customers org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet Data Source org.eclipse.birt.report.data.oda.jdbc odaDriverClass org.eclipse.birt.report.data.oda.sampledb.Driver odaURL jdbc:classicmodels:sampledb odaDataSource odaUser ClassicModels odaPassword odaJndiName select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME, CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER from CLASSICMODELS.CUSTOMERS queryTimeOut CUSTOMERNAME 1 12 CUSTOMERNUMBER 2 4 true row["CUSTOMERNUMBER"] row["CUSTOMERNAME"] SelectableListWithTextField true row["ORDERNUMBER"] row["ORDERNUMBER"] SelectableListWithTextField ORDERNUMBER 1 4 10 0 Nullable ORDERNUMBER 11 PRODUCTCODE 2 12 15 0 Nullable PRODUCTCODE 15 QUANTITYORDERED 3 4 10 0 Nullable QUANTITYORDERED 11 PRICEEACH 4 8 15 0 Nullable PRICEEACH 22 ORDERLINENUMBER 5 5 5 0 Nullable ORDERLINENUMBER 6 ORDERNUMBER 1 4 PRODUCTCODE 2 12 QUANTITYORDERED 3 4 PRICEEACH 4 8 ORDERLINENUMBER 5 5 ]]> html new Date()]]> 100%orderdetails ORDERNUMBER dataSetRow["ORDERNUMBER"] integer PRODUCTCODE dataSetRow["PRODUCTCODE"] string QUANTITYORDERED dataSetRow["QUANTITYORDERED"] integer PRICEEACH dataSetRow["PRICEEACH"] float ORDERLINENUMBER dataSetRow["ORDERLINENUMBER"] integer
ORDERNUMBER PRODUCTCODE QUANTITYORDERED PRICEEACH ORDERLINENUMBER