blob: 37052f272b8813ea55efbfa22768324047a1b826 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 0.0 (http://www.eclipse.com) -->
<report xmlns="http://www.eclipse.com/schemas/BIRT_schema.xsd">
<property name="createdBy">Eclipse BIRT Designer Version 0.0.1 Build &lt;20050405-1230></property>
<property name="units">in</property>
<data-sources>
<oda-data-source name="sfdata">
<list-property name="userProperties">
<structure>
<property name="name">valid</property>
<property name="type">string</property>
</structure>
</list-property>
<property name="valid">true</property>
<property name="driverName">jdbc</property>
<list-property name="privateDriverProperties">
<ex-property>
<name>ODA:url</name>
<value>jdbc:odbc:sfdata</value>
</ex-property>
<ex-property>
<name>ODA:user</name>
</ex-property>
<ex-property>
<name>ODA:password</name>
</ex-property>
<ex-property>
<name>ODA:driver-class</name>
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</ex-property>
</list-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set name="Invoice">
<property name="dataSource">sfdata</property>
<property name="queryText">SELECT [orders].[orderID],
[orders].[forecastOrderDate],
[orders].[shipByDate],
[orders].[forecastShipDate],
[orders].[status],
[orders].[issue],
[orders].[askByDate],
[orders].[custID],
[orders].[category],
[customers].[custID],
[customers].[contact_last],
[customers].[contact_first],
[customers].[customName],
[customers].[phone],
[customers].[address],
[customers].[city],
[customers].[state],
[customers].[postalcode],
[customers].[creditrank],
[customers].[purchaseFrequency],
[customers].[purchaseVolume],
[customers].[repID]
FROM ([orders] INNER JOIN [customers] ON [orders].[custID] = [customers].[custID] )
WHERE OrderID = 1150</property>
<property name="type">JdbcSelectDataSet</property>
</oda-data-set>
<oda-data-set name="Line Items">
<property name="dataSource">sfdata</property>
<list-property name="computedColumns">
<structure>
<property name="columnName">extension</property>
<expression name="expression">row["pricequote"]*row["quantity"]</expression>
</structure>
</list-property>
<property name="queryText">SELECT [items].[itemcode],
[items].[description],
[items].[pricequote],
[items].[quantity],
[items].[category],
[items].[orderID]
FROM [items]
WHERE orderID = 1150</property>
<property name="type">JdbcSelectDataSet</property>
</oda-data-set>
</data-sets>
<styles>
<style name="Body Grid">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0.5pt</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">0.5pt</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0.5pt</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0.5pt</property>
</style>
<style name="Body Grid Header">
<property name="backgroundColor">#B3FFFF</property>
<property name="fontSize">8pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
</style>
<style name="Cell Border">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0.5pt</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">0.5pt</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0.5pt</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0.5pt</property>
<property name="paddingTop">2pt</property>
<property name="paddingBottom">2pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">center</property>
<property name="verticalAlign">middle</property>
</style>
<style name="Detail Cell">
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">0.5pt</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">0.5pt</property>
<property name="paddingTop">2pt</property>
<property name="paddingLeft">4pt</property>
<property name="paddingBottom">2pt</property>
<property name="paddingRight">4pt</property>
<property name="verticalAlign">top</property>
</style>
<style name="report">
<property name="fontFamily">sans-serif</property>
</style>
<style name="Detail Footer">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0.5pt</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0.5pt</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
</style>
<style name="Footer Cell">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">0.5pt</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">0.5pt</property>
<property name="paddingTop">2pt</property>
<property name="paddingLeft">4pt</property>
<property name="paddingBottom">2pt</property>
<property name="paddingRight">4pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage">
<page-header>
<grid>
<property name="width">100%</property>
<column/>
<row>
<cell>
<property name="fontSize">xx-large</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text>
<text-property name="content"><![CDATA[Title]]></text-property>
</text>
</cell>
</row>
</grid>
</page-header>
<page-footer>
<grid>
<property name="width">100%</property>
<column/>
<column/>
<row>
<cell>
<text>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</cell>
<cell>
<property name="textAlign">right</property>
<text>
<text-property name="content"><![CDATA[Page:]]></text-property>
</text>
</cell>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<list>
<header>
<grid>
<property name="width">100%</property>
<column>
<property name="width">1in</property>
</column>
<column>
<property name="width">3in</property>
</column>
<column/>
<column>
<property name="width">2in</property>
</column>
<row>
<cell>
<property name="colSpan">1</property>
<property name="rowSpan">1</property>
<image>
<expression name="uri">http://www.eclipse.org/birt/examples/multichip-6.jpg</expression>
</image>
</cell>
<cell>
<property name="colSpan">1</property>
<property name="rowSpan">1</property>
<text>
<property name="textAlign">center</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<FONT size="24"><b>MultiChip Technology Corp.</FONT><br>
1234 Technology Circle<br>
Vacas Grandes, CA 99887<br>
<br>
(555) 123-4567]]></text-property>
</text>
</cell>
<cell/>
<cell>
<property name="drop">none</property>
<property name="height">0.25in</property>
<property name="textAlign">left</property>
<property name="verticalAlign">top</property>
<property name="canShrink">false</property>
<grid>
<property name="width">100%</property>
<property name="dataSet">Invoice</property>
<column>
<property name="width">0.947in</property>
</column>
<column>
<property name="width">1.041in</property>
</column>
<row>
<cell>
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<label>
<property name="backgroundColor">#0080FF</property>
<property name="fontSize">14pt</property>
<property name="fontWeight">900</property>
<property name="color">#FFFFFF</property>
<property name="marginBottom">4pt</property>
<property name="paddingTop">2pt</property>
<property name="paddingBottom">2pt</property>
<property name="textAlign">center</property>
<text-property name="text">Invoice</text-property>
</label>
</cell>
</row>
<row>
<cell>
<label>
<property name="fontSize">7pt</property>
<text-property name="text">DATE</text-property>
</label>
</cell>
<cell>
<label>
<property name="fontSize">7pt</property>
<property name="textAlign">right</property>
<text-property name="text">INVOICE NO.</text-property>
</label>
</cell>
</row>
<row>
<cell>
<data>
<property name="fontWeight">bold</property>
<property name="dateTimeFormat">Short Date</property>
<expression name="valueExpr">row["forecastOrderDate"]</expression>
</data>
</cell>
<cell>
<data>
<property name="fontWeight">bold</property>
<property name="numberFormat">#####</property>
<property name="textAlign">right</property>
<expression name="valueExpr">row["orderID"]</expression>
</data>
</cell>
</row>
</grid>
</cell>
</row>
</grid>
<grid>
<property name="marginLeft">0.25in</property>
<property name="canShrink">false</property>
<property name="height">2in</property>
<property name="width">100%</property>
<property name="dataSet">Invoice</property>
<column>
<property name="width">0.718in</property>
</column>
<column>
<property name="width">2.427in</property>
</column>
<column>
<property name="width">0.739in</property>
</column>
<column>
<property name="width">2.406in</property>
</column>
<row>
<property name="height">0.5in</property>
<cell/>
<cell/>
<cell/>
<cell/>
</row>
<row>
<cell>
<label>
<property name="fontSize">7pt</property>
<text-property name="text">BILL TO:</text-property>
</label>
</cell>
<cell>
<data>
<expression name="valueExpr">row["customName"]</expression>
</data>
</cell>
<cell>
<label>
<property name="fontSize">7pt</property>
<text-property name="text">SHIP TO:</text-property>
</label>
</cell>
<cell>
<label>
<text-property name="text">Same</text-property>
</label>
</cell>
</row>
<row>
<cell/>
<cell>
<data>
<expression name="valueExpr">row["address"]</expression>
</data>
</cell>
<cell/>
<cell/>
</row>
<row>
<cell/>
<cell>
<text>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<VALUE-OF>row["city"]</VALUE-OF>,
<VALUE-OF>row["state"]</VALUE-OF>
<VALUE-OF>row["postalcode"]</VALUE-OF>]]></text-property>
</text>
</cell>
<cell/>
<cell/>
</row>
<row>
<property name="height">0.5in</property>
<cell/>
<cell/>
<cell/>
<cell/>
</row>
</grid>
<grid>
<property name="style">Body Grid</property>
<property name="width">100%</property>
<property name="dataSet">Invoice</property>
<column/>
<column/>
<column/>
<column/>
<column/>
<column/>
<row>
<property name="style">Body Grid Header</property>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">P.O. NUMBER</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">TERMS</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">REP</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">SHIP</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">VIA</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">F.O.B.</text-property>
</label>
</cell>
</row>
<row>
<cell>
<property name="style">Cell Border</property>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">NET30</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<data>
<property name="numberFormat">#####</property>
<expression name="valueExpr">row["repID"]</expression>
</data>
</cell>
<cell>
<property name="style">Cell Border</property>
<data>
<property name="dateTimeFormat">Short Date</property>
<expression name="valueExpr">row["forecastShipDate"]</expression>
</data>
</cell>
<cell>
<property name="style">Cell Border</property>
</cell>
<cell>
<property name="style">Cell Border</property>
</cell>
</row>
</grid>
<table>
<property name="style">Body Grid</property>
<property name="width">100%</property>
<property name="dataSet">Line Items</property>
<column>
<property name="width">0.75in</property>
</column>
<column>
<property name="width">1in</property>
</column>
<column/>
<column>
<property name="width">0.75in</property>
</column>
<column>
<property name="width">1in</property>
</column>
<header>
<row>
<property name="style">Body Grid Header</property>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">QUANTITY</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">ITEM CODE</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">DESCRIPTION</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">PRICE EACH</text-property>
</label>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<text-property name="text">AMOUNT</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row>
<cell>
<property name="style">Detail Cell</property>
<data>
<property name="textAlign">right</property>
<expression name="valueExpr">row["quantity"]</expression>
</data>
</cell>
<cell>
<property name="style">Detail Cell</property>
<data>
<expression name="valueExpr">row["itemcode"]</expression>
</data>
</cell>
<cell>
<property name="style">Detail Cell</property>
<data>
<expression name="valueExpr">row["description"]</expression>
</data>
</cell>
<cell>
<property name="style">Detail Cell</property>
<data>
<property name="numberFormat">#,###.00</property>
<property name="textAlign">right</property>
<expression name="valueExpr">row["pricequote"]</expression>
</data>
</cell>
<cell>
<property name="style">Detail Cell</property>
<data>
<property name="numberFormat">##,###.00</property>
<property name="textAlign">right</property>
<expression name="valueExpr">row["extension"]</expression>
</data>
</cell>
</row>
</detail>
<footer>
<row>
<property name="fontWeight">bold</property>
<cell>
<property name="style">Footer Cell</property>
</cell>
<cell>
<property name="style">Footer Cell</property>
</cell>
<cell>
<property name="style">Footer Cell</property>
</cell>
<cell>
<property name="style">Cell Border</property>
<label>
<property name="textAlign">center</property>
<text-property name="text">TOTAL</text-property>
</label>
</cell>
<cell>
<property name="style">Footer Cell</property>
<data>
<property name="numberFormat">$##,###.00</property>
<property name="textAlign">right</property>
<expression name="valueExpr">Total.sum( row.extension )</expression>
</data>
</cell>
</row>
</footer>
</table>
</header>
</list>
</body>
</report>