examples/solution/invoice.rptdesign

<?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>