Attachment 110060 Details for Bug 239925 – report design file

Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

report design file

239925.rptdesign (text/xml), 21.75 KB, created by Sissi Zhu

on 2008-08-14 23:10:58 EDT

(hide)

Description:

Filename:

MIME Type:

Creator: Sissi Zhu

Created: 2008-08-14 23:10:58 EDT

Size: 21.75 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8"?>
><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
>    <property name="createdBy">Eclipse BIRT Designer Version 2.3.1.v20080814-0630 Build &lt;2.3.1.v20080814-0630></property>
>    <property name="units">in</property>
>    <property name="iconFile">/templates/blank_report.gif</property>
>    <property name="bidiLayoutOrientation">ltr</property>
>    <data-sources>
>        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="6">
>            <text-property name="displayName"></text-property>
>            <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
>            <property name="odaURL">jdbc:classicmodels:sampledb</property>
>            <property name="odaUser">ClassicModels</property>
>            <property name="OdaConnProfileName"></property>
>        </oda-data-source>
>    </data-sources>
>    <data-sets>
>        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="7">
>            <structure name="cachedMetaData">
>                <list-property name="resultSet">
>                    <structure>
>                        <property name="position">1</property>
>                        <property name="name">OFFICECODE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">2</property>
>                        <property name="name">CITY</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">3</property>
>                        <property name="name">PHONE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">4</property>
>                        <property name="name">ADDRESSLINE1</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">5</property>
>                        <property name="name">ADDRESSLINE2</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">6</property>
>                        <property name="name">STATE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">7</property>
>                        <property name="name">COUNTRY</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">8</property>
>                        <property name="name">POSTALCODE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">9</property>
>                        <property name="name">TERRITORY</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                </list-property>
>            </structure>
>            <property name="dataSource">Data Source</property>
>            <list-property name="resultSet">
>                <structure>
>                    <property name="position">1</property>
>                    <property name="name">OFFICECODE</property>
>                    <property name="nativeName">OFFICECODE</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">2</property>
>                    <property name="name">CITY</property>
>                    <property name="nativeName">CITY</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">3</property>
>                    <property name="name">PHONE</property>
>                    <property name="nativeName">PHONE</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">4</property>
>                    <property name="name">ADDRESSLINE1</property>
>                    <property name="nativeName">ADDRESSLINE1</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">5</property>
>                    <property name="name">ADDRESSLINE2</property>
>                    <property name="nativeName">ADDRESSLINE2</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">6</property>
>                    <property name="name">STATE</property>
>                    <property name="nativeName">STATE</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">7</property>
>                    <property name="name">COUNTRY</property>
>                    <property name="nativeName">COUNTRY</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">8</property>
>                    <property name="name">POSTALCODE</property>
>                    <property name="nativeName">POSTALCODE</property>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="position">9</property>
>                    <property name="name">TERRITORY</property>
>                    <property name="nativeName">TERRITORY</property>
>                    <property name="dataType">string</property>
>                </structure>
>            </list-property>
>            <property name="queryText">select *
>from CLASSICMODELS.OFFICES</property>
>            <xml-property name="designerValues"><![CDATA[]]></xml-property>
>        </oda-data-set>
>    </data-sets>
>    <cubes>
>        <tabular-cube name="Data Cube" id="8">
>            <property name="dimensions">
>                <tabular-dimension name="Group" id="9">
>                    <property name="defaultHierarchy">NewTabularHierarchy</property>
>                    <property name="hierarchies">
>                        <tabular-hierarchy name="NewTabularHierarchy" id="10">
>                            <property name="levels">
>                                <tabular-level name="COUNTRY" id="11">
>                                    <property name="dataType">string</property>
>                                    <property name="columnName">COUNTRY</property>
>                                </tabular-level>
>                                <tabular-level name="CITY" id="12">
>                                    <property name="dataType">string</property>
>                                    <property name="columnName">CITY</property>
>                                </tabular-level>
>                            </property>
>                        </tabular-hierarchy>
>                    </property>
>                </tabular-dimension>
>                <tabular-dimension name="Group1" id="15">
>                    <property name="defaultHierarchy">NewTabularHierarchy1</property>
>                    <property name="hierarchies">
>                        <tabular-hierarchy name="NewTabularHierarchy1" id="16">
>                            <property name="levels">
>                                <tabular-level name="TERRITORY" id="17">
>                                    <property name="dataType">string</property>
>                                    <property name="columnName">TERRITORY</property>
>                                </tabular-level>
>                            </property>
>                        </tabular-hierarchy>
>                    </property>
>                </tabular-dimension>
>            </property>
>            <property name="measureGroups">
>                <tabular-measure-group name="Summary Field" id="13">
>                    <property name="measures">
>                        <tabular-measure name="OFFICECODE" id="14">
>                            <property name="function">count</property>
>                            <expression name="measureExpression">dataSetRow["OFFICECODE"]</expression>
>                            <property name="dataType">integer</property>
>                        </tabular-measure>
>                    </property>
>                </tabular-measure-group>
>            </property>
>            <property name="dataSet">Data Set</property>
>        </tabular-cube>
>    </cubes>
>    <styles>
>        <style name="crosstab" 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-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>
>    </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>
>        <extended-item extensionName="Crosstab" extensionVersion="2.3.0" id="49">
>            <property name="measures">
>                <extended-item extensionName="MeasureView" id="64">
>                    <property name="measure">OFFICECODE</property>
>                    <property name="detail">
>                        <extended-item extensionName="AggregationCell" id="65">
>                            <property name="aggregationOnRow">Group/CITY</property>
>                            <property name="aggregationOnColumn">Group1/TERRITORY</property>
>                            <property name="content">
>                                <data id="66">
>                                    <property name="resultSetColumn">OFFICECODE_Group/CITY_Group1/TERRITORY</property>
>                                </data>
>                            </property>
>                        </extended-item>
>                    </property>
>                    <property name="aggregations">
>                        <extended-item extensionName="AggregationCell" id="70">
>                            <property name="aggregationOnRow">Group/COUNTRY</property>
>                            <property name="aggregationOnColumn">Group1/TERRITORY</property>
>                            <property name="content">
>                                <data id="71">
>                                    <property name="resultSetColumn">OFFICECODE_Group/COUNTRY_Group1/TERRITORY</property>
>                                </data>
>                            </property>
>                        </extended-item>
>                        <extended-item extensionName="AggregationCell" id="74">
>                            <property name="aggregationOnColumn">Group1/TERRITORY</property>
>                            <property name="content">
>                                <data id="75">
>                                    <property name="resultSetColumn">OFFICECODE_Group1/TERRITORY</property>
>                                </data>
>                            </property>
>                        </extended-item>
>                    </property>
>                    <property name="header">
>                        <extended-item extensionName="CrosstabCell" id="67">
>                            <property name="content">
>                                <label id="68">
>                                    <text-property name="text">OFFICECODE</text-property>
>                                </label>
>                            </property>
>                        </extended-item>
>                    </property>
>                </extended-item>
>            </property>
>            <property name="rows">
>                <extended-item extensionName="CrosstabView" id="56">
>                    <property name="grandTotal">
>                        <extended-item extensionName="CrosstabCell" id="73">
>                            <property name="content">
>                                <label id="76">
>                                    <text-property name="text">Grand Total</text-property>
>                                </label>
>                            </property>
>                        </extended-item>
>                    </property>
>                    <property name="views">
>                        <extended-item extensionName="DimensionView" id="57">
>                            <property name="dimension">Group</property>
>                            <property name="levels">
>                                <extended-item extensionName="LevelView" name="NewLevel View1" id="58">
>                                    <property name="level">Group/COUNTRY</property>
>                                    <property name="member">
>                                        <extended-item extensionName="CrosstabCell" id="59">
>                                            <property name="content">
>                                                <data name="COUNTRY" id="60">
>                                                    <property name="resultSetColumn">COUNTRY</property>
>                                                </data>
>                                            </property>
>                                        </extended-item>
>                                    </property>
>                                    <property name="aggregationHeader">
>                                        <extended-item extensionName="CrosstabCell" id="69">
>                                            <property name="content">
>                                                <data name="COUNTRY_TOTAL" id="72">
>                                                    <property name="resultSetColumn">COUNTRY_TOTAL</property>
>                                                </data>
>                                            </property>
>                                        </extended-item>
>                                    </property>
>                                </extended-item>
>                                <extended-item extensionName="LevelView" name="NewLevel View2" id="61">
>                                    <property name="level">Group/CITY</property>
>                                    <property name="member">
>                                        <extended-item extensionName="CrosstabCell" id="62">
>                                            <property name="content">
>                                                <data name="CITY" id="63">
>                                                    <property name="resultSetColumn">CITY</property>
>                                                </data>
>                                            </property>
>                                        </extended-item>
>                                    </property>
>                                </extended-item>
>                            </property>
>                        </extended-item>
>                    </property>
>                </extended-item>
>            </property>
>            <property name="columns">
>                <extended-item extensionName="CrosstabView" id="51">
>                    <property name="views">
>                        <extended-item extensionName="DimensionView" id="52">
>                            <property name="dimension">Group1</property>
>                            <property name="levels">
>                                <extended-item extensionName="LevelView" name="NewLevel View" id="53">
>                                    <property name="level">Group1/TERRITORY</property>
>                                    <property name="member">
>                                        <extended-item extensionName="CrosstabCell" id="54">
>                                            <property name="content">
>                                                <data name="TERRITORY" id="55">
>                                                    <property name="resultSetColumn">TERRITORY</property>
>                                                </data>
>                                            </property>
>                                        </extended-item>
>                                    </property>
>                                </extended-item>
>                            </property>
>                        </extended-item>
>                    </property>
>                </extended-item>
>            </property>
>            <property name="header">
>                <extended-item extensionName="CrosstabCell" id="50"/>
>            </property>
>            <property name="cube">Data Cube</property>
>            <list-property name="boundDataColumns">
>                <structure>
>                    <property name="name">TERRITORY</property>
>                    <expression name="expression">dimension["Group1"]["TERRITORY"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">COUNTRY</property>
>                    <expression name="expression">dimension["Group"]["COUNTRY"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">CITY</property>
>                    <expression name="expression">dimension["Group"]["CITY"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">OFFICECODE_Group/CITY_Group1/TERRITORY</property>
>                    <expression name="expression">measure["OFFICECODE"]</expression>
>                    <property name="dataType">integer</property>
>                    <simple-property-list name="aggregateOn">
>                        <value>Group/CITY</value>
>                        <value>Group1/TERRITORY</value>
>                    </simple-property-list>
>                    <property name="aggregateFunction">sum</property>
>                </structure>
>                <structure>
>                    <property name="name">OFFICECODE_Group/COUNTRY_Group1/TERRITORY</property>
>                    <property name="dataType">integer</property>
>                    <simple-property-list name="aggregateOn">
>                        <value>Group/COUNTRY</value>
>                        <value>Group1/TERRITORY</value>
>                    </simple-property-list>
>                    <property name="aggregateFunction">SUM</property>
>                    <list-property name="arguments">
>                        <structure>
>                            <property name="name">Expression</property>
>                            <expression name="value">measure["OFFICECODE"]</expression>
>                        </structure>
>                    </list-property>
>                    <expression name="filterExpr">dimension["Group"]["COUNTRY"]=="USA"</expression>
>                </structure>
>                <structure>
>                    <property name="name">COUNTRY_TOTAL</property>
>                    <expression name="expression">dimension["Group"]["COUNTRY"]+" TOTAL"</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">OFFICECODE_Group1/TERRITORY</property>
>                    <expression name="expression">measure["OFFICECODE"]</expression>
>                    <property name="dataType">integer</property>
>                    <simple-property-list name="aggregateOn">
>                        <value>Group1/TERRITORY</value>
>                    </simple-property-list>
>                    <property name="aggregateFunction">sum</property>
>                </structure>
>            </list-property>
>        </extended-item>
>    </body>
></report>

Actions: View

Attachments on bug 239925: 110060