framework/webtools/webapp/birt/report/product.rptdesign

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903 Build &lt;2.5.1.v20090917-1447></property>
    <property name="units">in</property>
    <method name="initialize"><![CDATA[importPackage(Packages.org.ofbiz.base.util)

module = "product.rptdesign";]]></method>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <data-sources>
        <script-data-source name="OFBiz" id="8"/>
    </data-sources>
    <data-sets>
        <script-data-set name="Product" id="9">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">0</property>
                    <property name="name">productId</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">1</property>
                    <property name="name">productTypeId</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">internalName</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">productId</property>
                    <text-property name="displayName">productId</text-property>
                </structure>
                <structure>
                    <property name="columnName">productTypeId</property>
                    <text-property name="displayName">productTypeId</text-property>
                </structure>
                <structure>
                    <property name="columnName">internalName</property>
                    <text-property name="displayName">internalName</text-property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">productId</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">productTypeId</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">internalName</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">OFBiz</property>
            <method name="open"><![CDATA[products = null;
try {
    products = delegator.findAll("Product");
} catch (e) {
    Debug.logError(e, module);
}
totalRow = 0;
countOfRow = 0;
if (products) {
    totalRow = products.size();
}]]></method>
            <method name="fetch"><![CDATA[if (countOfRow == totalRow - 1) return false;

product = products.get(countOfRow);
productId = product.getString("productId");
productTypeId = product.getString("productTypeId");
internalName = product.getString("internalName");

row["productId"] = productId;
row["productTypeId"] = productTypeId;
row["internalName"] = internalName;

countOfRow ++;
return true;]]></method>
        </script-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" 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>
        <style name="crosstab" id="6">
            <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="10">
            <property name="dataSet">Product</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">productId</property>
                    <text-property name="displayName">productId</text-property>
                    <expression name="expression">dataSetRow["productId"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">productTypeId</property>
                    <text-property name="displayName">productTypeId</text-property>
                    <expression name="expression">dataSetRow["productTypeId"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">internalName</property>
                    <text-property name="displayName">internalName</text-property>
                    <expression name="expression">dataSetRow["internalName"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="29"/>
            <column id="30"/>
            <column id="31"/>
            <header>
                <row id="11">
                    <property name="backgroundColor">#BFBFBF</property>
                    <property name="fontWeight">bold</property>
                    <property name="textAlign">center</property>
                    <cell id="12">
                        <label id="13">
                            <text-property name="text">productId</text-property>
                        </label>
                    </cell>
                    <cell id="14">
                        <label id="15">
                            <text-property name="text">productTypeId</text-property>
                        </label>
                    </cell>
                    <cell id="16">
                        <label id="17">
                            <text-property name="text">internalName</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="18">
                    <cell id="19">
                        <data id="20">
                            <property name="resultSetColumn">productId</property>
                        </data>
                    </cell>
                    <cell id="21">
                        <data id="22">
                            <property name="resultSetColumn">productTypeId</property>
                        </data>
                    </cell>
                    <cell id="23">
                        <data id="24">
                            <property name="resultSetColumn">internalName</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="25">
                    <cell id="26"/>
                    <cell id="27"/>
                    <cell id="28"/>
                </row>
            </footer>
        </table>
    </body>
</report>