Attachment 93895 Details for Bug 224263 – Product Sales by Country.rptdesign

Product Sales by Country.rptdesign

Product Sales by Country.rptdesign (text/plain), 23.37 KB, created by Paul Rogers

on 2008-03-27 18:18:13 EDT

(hide)

Description:

Filename:

MIME Type:

Creator: Paul Rogers

Created: 2008-03-27 18:18:13 EDT

Size: 23.37 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8"?>
><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">
>    <property name="createdBy">Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build &lt;2.2.2.v20080227-1131></property>
>    <property name="units">in</property>
>    <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name here>></property>
>    <html-property name="description">Creates a blank report with no predefined content.</html-property>
>    <text-property name="displayName">Blank Report</text-property>
>    <property name="iconFile">/templates/blank_report.gif</property>
>    <data-sources>
>        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Classic Models" id="6">
>            <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
>            <property name="odaURL">jdbc:classicmodels:sampledb</property>
>            <property name="odaUser">ClassicModels</property>
>        </oda-data-source>
>    </data-sources>
>    <data-sets>
>        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Product Sales by Customer" id="7">
>            <list-property name="columnHints">
>                <structure>
>                    <property name="columnName">CUSTOMERNUMBER</property>
>                    <property name="displayName">CUSTOMERNUMBER</property>
>                </structure>
>                <structure>
>                    <property name="columnName">CUSTOMERNAME</property>
>                    <property name="displayName">CUSTOMERNAME</property>
>                </structure>
>                <structure>
>                    <property name="columnName">STATE</property>
>                    <property name="displayName">STATE</property>
>                </structure>
>                <structure>
>                    <property name="columnName">COUNTRY</property>
>                    <property name="displayName">COUNTRY</property>
>                </structure>
>                <structure>
>                    <property name="columnName">ORDERNUMBER</property>
>                    <property name="displayName">ORDERNUMBER</property>
>                </structure>
>                <structure>
>                    <property name="columnName">ORDERDATE</property>
>                    <property name="displayName">ORDERDATE</property>
>                </structure>
>                <structure>
>                    <property name="columnName">QUANTITYORDERED</property>
>                    <property name="displayName">QUANTITYORDERED</property>
>                </structure>
>                <structure>
>                    <property name="columnName">PRICEEACH</property>
>                    <property name="displayName">PRICEEACH</property>
>                </structure>
>            </list-property>
>            <structure name="cachedMetaData">
>                <list-property name="resultSet">
>                    <structure>
>                        <property name="position">1</property>
>                        <property name="name">CUSTOMERNUMBER</property>
>                        <property name="dataType">integer</property>
>                    </structure>
>                    <structure>
>                        <property name="position">2</property>
>                        <property name="name">CUSTOMERNAME</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">3</property>
>                        <property name="name">STATE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">4</property>
>                        <property name="name">COUNTRY</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">5</property>
>                        <property name="name">ORDERNUMBER</property>
>                        <property name="dataType">integer</property>
>                    </structure>
>                    <structure>
>                        <property name="position">6</property>
>                        <property name="name">ORDERDATE</property>
>                        <property name="dataType">date</property>
>                    </structure>
>                    <structure>
>                        <property name="position">7</property>
>                        <property name="name">QUANTITYORDERED</property>
>                        <property name="dataType">integer</property>
>                    </structure>
>                    <structure>
>                        <property name="position">8</property>
>                        <property name="name">PRICEEACH</property>
>                        <property name="dataType">float</property>
>                    </structure>
>                </list-property>
>            </structure>
>            <property name="dataSource">Classic Models</property>
>            <list-property name="resultSet">
>                <structure>
>                    <property name="position">1</property>
>                    <property name="name">CUSTOMERNUMBER</property>
>                    <property name="nativeName">CUSTOMERNUMBER</property>
>                    <property name="dataType">integer</property>
>                    <property name="nativeDataType">4</property>
>                </structure>
>                <structure>
>                    <property name="position">2</property>
>                    <property name="name">CUSTOMERNAME</property>
>                    <property name="nativeName">CUSTOMERNAME</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">3</property>
>                    <property name="name">STATE</property>
>                    <property name="nativeName">STATE</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">4</property>
>                    <property name="name">COUNTRY</property>
>                    <property name="nativeName">COUNTRY</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">5</property>
>                    <property name="name">ORDERNUMBER</property>
>                    <property name="nativeName">ORDERNUMBER</property>
>                    <property name="dataType">integer</property>
>                    <property name="nativeDataType">4</property>
>                </structure>
>                <structure>
>                    <property name="position">6</property>
>                    <property name="name">ORDERDATE</property>
>                    <property name="nativeName">ORDERDATE</property>
>                    <property name="dataType">date</property>
>                    <property name="nativeDataType">91</property>
>                </structure>
>                <structure>
>                    <property name="position">7</property>
>                    <property name="name">QUANTITYORDERED</property>
>                    <property name="nativeName">QUANTITYORDERED</property>
>                    <property name="dataType">integer</property>
>                    <property name="nativeDataType">4</property>
>                </structure>
>                <structure>
>                    <property name="position">8</property>
>                    <property name="name">PRICEEACH</property>
>                    <property name="nativeName">PRICEEACH</property>
>                    <property name="dataType">float</property>
>                    <property name="nativeDataType">8</property>
>                </structure>
>            </list-property>
>            <property name="queryText">select 	CUSTOMERS.CUSTOMERNUMBER,
>		CUSTOMERS.CUSTOMERNAME,
>		CUSTOMERS.STATE,
>		CUSTOMERS.COUNTRY,
>		ORDERS.ORDERNUMBER,
>		ORDERS.ORDERDATE,
>		ORDERDETAILS.QUANTITYORDERED,
>		ORDERDETAILS.PRICEEACH
>from 	CUSTOMERS, ORDERS, ORDERDETAILS
>where 	CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER
>  and	ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
>order by COUNTRY, CUSTOMERNAME</property>
>        </oda-data-set>
>    </data-sets>
>    <styles>
>        <style name="crosstab-cell" id="4">
>            <property name="borderBottomColor">#CCCCCC</property>
>            <property name="borderBottomStyle">solid</property>
>            <property name="borderBottomWidth">1pt</property>
>            <property name="borderLeftColor">#CCCCCC</property>
>            <property name="borderLeftStyle">solid</property>
>            <property name="borderLeftWidth">1pt</property>
>            <property name="borderRightColor">#CCCCCC</property>
>            <property name="borderRightStyle">solid</property>
>            <property name="borderRightWidth">1pt</property>
>            <property name="borderTopColor">#CCCCCC</property>
>            <property name="borderTopStyle">solid</property>
>            <property name="borderTopWidth">1pt</property>
>        </style>
>        <style name="crosstab" id="5">
>            <property name="borderBottomColor">#CCCCCC</property>
>            <property name="borderBottomStyle">solid</property>
>            <property name="borderBottomWidth">1pt</property>
>            <property name="borderLeftColor">#CCCCCC</property>
>            <property name="borderLeftStyle">solid</property>
>            <property name="borderLeftWidth">1pt</property>
>            <property name="borderRightColor">#CCCCCC</property>
>            <property name="borderRightStyle">solid</property>
>            <property name="borderRightWidth">1pt</property>
>            <property name="borderTopColor">#CCCCCC</property>
>            <property name="borderTopStyle">solid</property>
>            <property name="borderTopWidth">1pt</property>
>        </style>
>    </styles>
>    <page-setup>
>        <simple-master-page name="Simple MasterPage" id="2">
>            <page-footer>
>                <text id="3">
>                    <property name="contentType">html</property>
>                    <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
>                </text>
>            </page-footer>
>        </simple-master-page>
>    </page-setup>
>    <body>
>        <table id="8">
>            <property name="width">100%</property>
>            <property name="dataSet">Product Sales by Customer</property>
>            <list-property name="boundDataColumns">
>                <structure>
>                    <property name="name">CUSTOMERNUMBER</property>
>                    <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression>
>                    <property name="dataType">integer</property>
>                </structure>
>                <structure>
>                    <property name="name">CUSTOMERNAME</property>
>                    <expression name="expression">dataSetRow["CUSTOMERNAME"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">COUNTRY</property>
>                    <expression name="expression">dataSetRow["COUNTRY"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">ORDERNUMBER</property>
>                    <expression name="expression">dataSetRow["ORDERNUMBER"]</expression>
>                    <property name="dataType">integer</property>
>                </structure>
>                <structure>
>                    <property name="name">QUANTITYORDERED</property>
>                    <expression name="expression">dataSetRow["QUANTITYORDERED"]</expression>
>                    <property name="dataType">integer</property>
>                </structure>
>                <structure>
>                    <property name="name">PRICEEACH</property>
>                    <expression name="expression">dataSetRow["PRICEEACH"]</expression>
>                    <property name="dataType">float</property>
>                </structure>
>                <structure>
>                    <property name="name">STATE</property>
>                    <expression name="expression">dataSetRow["STATE"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">Sales_2005</property>
>                    <property name="displayName">2005 Sales</property>
>                    <expression name="expression">dataSetRow["PRICEEACH"] * dataSetRow["QUANTITYORDERED"]</expression>
>                    <property name="dataType">any</property>
>                    <simple-property-list name="aggregateOn">
>                        <value>Customer</value>
>                    </simple-property-list>
>                    <property name="aggregateFunction">SUM</property>
>                    <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2005, 1, 1 ) &amp;&amp;
>dataSetRow["ORDERDATE"] &lt; new Date( 2006, 1, 1 )</expression>
>                </structure>
>                <structure>
>                    <property name="name">2005 Sales</property>
>                    <property name="displayName">2005 Sales</property>
>                    <expression name="expression">row["Sales_2005"]</expression>
>                    <property name="dataType">any</property>
>                </structure>
>                <structure>
>                    <property name="name">Sales_2006</property>
>                    <property name="displayName">2006 Sales</property>
>                    <expression name="expression">dataSetRow["PRICEEACH"] * dataSetRow["QUANTITYORDERED"]</expression>
>                    <property name="dataType">any</property>
>                    <property name="aggregateFunction">SUM</property>
>                    <expression name="filterExpr">dataSetRow["ORDERDATE"] >= new Date( 2006, 1, 1 ) &amp;&amp;
>dataSetRow["ORDERDATE"] &lt; new Date( 2007, 1, 1 )</expression>
>                </structure>
>                <structure>
>                    <property name="name">2006 Sales</property>
>                    <property name="displayName">2006 Sales</property>
>                    <expression name="expression">row["Sales_2006"]</expression>
>                    <property name="dataType">any</property>
>                </structure>
>                <structure>
>                    <property name="name">Column Binding</property>
>                    <expression name="expression">row["Sales_2006"] - row["Sales_2005"]</expression>
>                    <property name="dataType">any</property>
>                </structure>
>            </list-property>
>            <column id="21">
>                <property name="width">0.8020833333in</property>
>            </column>
>            <column id="22">
>                <property name="width">0.5520833333in</property>
>            </column>
>            <column id="23"/>
>            <column id="27"/>
>            <column id="31"/>
>            <column id="86"/>
>            <column id="94"/>
>            <header>
>                <row id="9">
>                    <cell id="10">
>                        <label id="76">
>                            <property name="textAlign">left</property>
>                            <text-property name="text">Country</text-property>
>                        </label>
>                    </cell>
>                    <cell id="11">
>                        <label id="72">
>                            <property name="textAlign">left</property>
>                            <text-property name="text">State</text-property>
>                        </label>
>                    </cell>
>                    <cell id="12">
>                        <label id="77">
>                            <property name="textAlign">left</property>
>                            <text-property name="text">Customer</text-property>
>                        </label>
>                    </cell>
>                    <cell id="24">
>                        <label id="95">
>                            <text-property name="text">2005 Sales</text-property>
>                        </label>
>                    </cell>
>                    <cell id="28">
>                        <label id="96">
>                            <text-property name="text">2006 Sales</text-property>
>                        </label>
>                    </cell>
>                    <cell id="79">
>                        <label id="97">
>                            <text-property name="text">Change</text-property>
>                        </label>
>                    </cell>
>                    <cell id="87"/>
>                </row>
>            </header>
>            <group id="59">
>                <property name="groupName">country</property>
>                <property name="interval">none</property>
>                <property name="sortDirection">asc</property>
>                <expression name="keyExpr">row["COUNTRY"]</expression>
>                <structure name="toc">
>                    <expression name="expressionValue">row["COUNTRY"]</expression>
>                </structure>
>                <property name="repeatHeader">true</property>
>                <property name="hideDetail">false</property>
>                <property name="pageBreakAfter">auto</property>
>                <property name="pageBreakBefore">auto</property>
>                <property name="pageBreakInside">auto</property>
>                <header>
>                    <row id="60">
>                        <cell id="61">
>                            <property name="colSpan">3</property>
>                            <property name="rowSpan">1</property>
>                            <data id="150">
>                                <property name="resultSetColumn">COUNTRY</property>
>                            </data>
>                        </cell>
>                        <cell id="64"/>
>                        <cell id="65"/>
>                        <cell id="80"/>
>                        <cell id="88"/>
>                    </row>
>                </header>
>                <footer>
>                    <row id="66">
>                        <cell id="67"/>
>                        <cell id="68"/>
>                        <cell id="69"/>
>                        <cell id="70"/>
>                        <cell id="71"/>
>                        <cell id="84"/>
>                        <cell id="92"/>
>                    </row>
>                </footer>
>            </group>
>            <group id="32">
>                <property name="groupName">State</property>
>                <property name="interval">none</property>
>                <property name="sortDirection">asc</property>
>                <expression name="keyExpr">row["STATE"]</expression>
>                <structure name="toc">
>                    <expression name="expressionValue">row["STATE"]</expression>
>                </structure>
>                <property name="repeatHeader">true</property>
>                <property name="hideDetail">false</property>
>                <property name="pageBreakAfter">auto</property>
>                <property name="pageBreakBefore">auto</property>
>                <property name="pageBreakInside">auto</property>
>                <header>
>                    <row id="33">
>                        <cell id="34"/>
>                        <cell id="35">
>                            <property name="colSpan">2</property>
>                            <property name="rowSpan">1</property>
>                            <data id="151">
>                                <property name="resultSetColumn">STATE</property>
>                            </data>
>                        </cell>
>                        <cell id="37"/>
>                        <cell id="38"/>
>                        <cell id="81"/>
>                        <cell id="89"/>
>                    </row>
>                </header>
>                <footer>
>                    <row id="39">
>                        <cell id="40"/>
>                        <cell id="41"/>
>                        <cell id="42"/>
>                        <cell id="43"/>
>                        <cell id="44"/>
>                        <cell id="83"/>
>                        <cell id="91"/>
>                    </row>
>                </footer>
>            </group>
>            <group id="133">
>                <property name="groupName">Customer</property>
>                <property name="interval">none</property>
>                <property name="sortDirection">asc</property>
>                <expression name="keyExpr">row["CUSTOMERNAME"]</expression>
>                <property name="repeatHeader">true</property>
>                <property name="hideDetail">false</property>
>                <property name="pageBreakAfter">auto</property>
>                <property name="pageBreakBefore">auto</property>
>                <property name="pageBreakInside">auto</property>
>                <header>
>                    <row id="134">
>                        <cell id="135"/>
>                        <cell id="136"/>
>                        <cell id="137">
>                            <data id="152">
>                                <property name="resultSetColumn">CUSTOMERNAME</property>
>                            </data>
>                        </cell>
>                        <cell id="138">
>                            <data id="156">
>                                <property name="resultSetColumn">2005 Sales</property>
>                            </data>
>                        </cell>
>                        <cell id="139">
>                            <data id="157">
>                                <property name="resultSetColumn">2006 Sales</property>
>                            </data>
>                        </cell>
>                        <cell id="140">
>                            <data id="159">
>                                <property name="resultSetColumn">Column Binding</property>
>                            </data>
>                        </cell>
>                        <cell id="141"/>
>                    </row>
>                </header>
>                <footer>
>                    <row id="142">
>                        <cell id="143"/>
>                        <cell id="144"/>
>                        <cell id="145"/>
>                        <cell id="146"/>
>                        <cell id="147"/>
>                        <cell id="148"/>
>                        <cell id="149"/>
>                    </row>
>                </footer>
>            </group>
>            <detail>
>                <row id="13">
>                    <cell id="14"/>
>                    <cell id="15"/>
>                    <cell id="16"/>
>                    <cell id="25"/>
>                    <cell id="29"/>
>                    <cell id="82"/>
>                    <cell id="90"/>
>                </row>
>            </detail>
>            <footer>
>                <row id="17">
>                    <cell id="18"/>
>                    <cell id="19"/>
>                    <cell id="20"/>
>                    <cell id="26"/>
>                    <cell id="30"/>
>                    <cell id="85"/>
>                    <cell id="93"/>
>                </row>
>            </footer>
>        </table>
>    </body>
></report>

Actions: View

Attachments on bug 224263: 93728 | 93895