Attachment 58491 Details for Bug 173355 – report design

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

report design

count.rptdesign (text/plain), 15.22 KB, created by Gary Xue

on 2007-02-07 16:41:56 EST

(hide)

Description:

Filename:

MIME Type:

Creator: Gary Xue

Created: 2007-02-07 16:41:56 EST

Size: 15.22 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8"?>
>
><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6" id="1">
>    <property name="createdBy">Eclipse BIRT Designer Version 2.1.1.v20060922-1058 Build &lt;20060926-0959></property>
>    <data-sources>
>        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="sample" id="231">
>            <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>
>            <encrypted-property name="odaPassword"></encrypted-property>
>        </oda-data-source>
>    </data-sources>
>    <data-sets>
>        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="sample data set" id="232">
>            <list-property name="computedColumns">
>                <structure>
>                    <property name="name">CountColumn</property>
>                    <expression name="expression">Total.count(Total.NO_FILTER, 1)</expression>
>                    <property name="dataType">integer</property>
>                </structure>
>            </list-property>
>            <structure name="cachedMetaData">
>                <list-property name="resultSet">
>                    <structure>
>                        <property name="position">1</property>
>                        <property name="name">LASTNAME</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">2</property>
>                        <property name="name">FIRSTNAME</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">3</property>
>                        <property name="name">OFFICECODE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">4</property>
>                        <property name="name">CountColumn</property>
>                        <property name="dataType">integer</property>
>                    </structure>
>                </list-property>
>            </structure>
>            <property name="dataSource">sample</property>
>            <list-property name="resultSet">
>                <structure>
>                    <property name="position">1</property>
>                    <property name="name">LASTNAME</property>
>                    <property name="nativeName">LASTNAME</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">2</property>
>                    <property name="name">FIRSTNAME</property>
>                    <property name="nativeName">FIRSTNAME</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">3</property>
>                    <property name="name">OFFICECODE</property>
>                    <property name="nativeName">OFFICECODE</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>            </list-property>
>            <property name="queryText">select LastName, FirstName, OFFICECODE
>from employees</property>
>            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
>  <Version>1.0</Version>
>  <design:ResultSets derivedMetaData="true">
>    <design:resultSetDefinitions>
>      <design:resultSetColumns>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>LASTNAME</design:name>
>            <design:position>1</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>            <design:precision>50</design:precision>
>            <design:scale>0</design:scale>
>            <design:nullability>Nullable</design:nullability>
>          </design:attributes>
>          <design:usageHints>
>            <design:label>LASTNAME</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>FIRSTNAME</design:name>
>            <design:position>2</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>            <design:precision>50</design:precision>
>            <design:scale>0</design:scale>
>            <design:nullability>Nullable</design:nullability>
>          </design:attributes>
>          <design:usageHints>
>            <design:label>FIRSTNAME</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>OFFICECODE</design:name>
>            <design:position>3</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>            <design:precision>10</design:precision>
>            <design:scale>0</design:scale>
>            <design:nullability>Nullable</design:nullability>
>          </design:attributes>
>          <design:usageHints>
>            <design:label>OFFICECODE</design:label>
>            <design:formattingHints>
>              <design:displaySize>10</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>      </design:resultSetColumns>
>    </design:resultSetDefinitions>
>    <design:resultSetDefinitions>
>      <design:resultSetColumns>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>LASTNAME</design:name>
>            <design:position>1</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>FIRSTNAME</design:name>
>            <design:position>2</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>OFFICECODE</design:name>
>            <design:position>3</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>      </design:resultSetColumns>
>    </design:resultSetDefinitions>
>  </design:ResultSets>
></model:DesignValues>]]></xml-property>
>        </oda-data-set>
>    </data-sets>
>    <styles>
>        <style name="title" id="2">
>            <property name="backgroundColor">#F3F5F7</property>
>            <property name="fontFamily">tahoma </property>
>            <property name="fontSize">medium</property>
>            <property name="fontWeight">bold</property>
>            <property name="color">black</property>
>        </style>
>        <style name="table" id="3">
>            <property name="backgroundColor">#F3F5F7</property>
>            <property name="fontFamily">tahoma </property>
>            <property name="fontSize">8pt</property>
>            <property name="color">black</property>
>            <property name="borderBottomColor">#CCCCCC</property>
>            <property name="borderBottomStyle">solid</property>
>            <property name="borderBottomWidth">thin</property>
>            <property name="borderLeftColor">#CCCCCC</property>
>            <property name="borderLeftStyle">dotted</property>
>            <property name="borderLeftWidth">thin</property>
>            <property name="borderRightColor">#CCCCCC</property>
>            <property name="borderRightStyle">solid</property>
>            <property name="borderRightWidth">thin</property>
>            <property name="borderTopColor">#CCCCCC</property>
>            <property name="borderTopStyle">solid</property>
>            <property name="borderTopWidth">thin</property>
>            <property name="marginTop">0pt</property>
>            <property name="marginLeft">0pt</property>
>            <property name="marginBottom">0pt</property>
>            <property name="marginRight">0pt</property>
>        </style>
>        <style name="cell" id="4">
>            <property name="borderBottomColor">white</property>
>            <property name="borderBottomStyle">solid</property>
>            <property name="borderBottomWidth">thin</property>
>        </style>
>        <style name="header" id="5">
>            <property name="backgroundColor">#CCCCCC</property>
>            <property name="fontFamily">tahoma </property>
>            <property name="fontSize">10pt</property>
>            <property name="fontWeight">bold</property>
>            <property name="color">black</property>
>        </style>
>        <style name="chart" id="6">
>            <property name="marginTop">0pt</property>
>            <property name="marginLeft">0pt</property>
>            <property name="marginBottom">0pt</property>
>            <property name="marginRight">0pt</property>
>        </style>
>    </styles>
>    <page-setup>
>        <simple-master-page name="NewSimpleMasterPage" id="230"/>
>    </page-setup>
>    <body>
>        <table id="233">
>            <property name="width">100%</property>
>            <property name="dataSet">sample data set</property>
>            <list-property name="boundDataColumns">
>                <structure>
>                    <property name="name">LASTNAME</property>
>                    <expression name="expression">dataSetRow["LASTNAME"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">FIRSTNAME</property>
>                    <expression name="expression">dataSetRow["FIRSTNAME"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">OFFICECODE</property>
>                    <expression name="expression">dataSetRow["OFFICECODE"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">CountColumn</property>
>                    <expression name="expression">dataSetRow["CountColumn"]</expression>
>                    <property name="dataType">integer</property>
>                </structure>
>            </list-property>
>            <column id="257"/>
>            <column id="258"/>
>            <column id="259"/>
>            <column id="260"/>
>            <header>
>                <row id="234">
>                    <cell id="235">
>                        <label id="236">
>                            <text-property name="text">LASTNAME</text-property>
>                        </label>
>                    </cell>
>                    <cell id="237">
>                        <label id="238">
>                            <text-property name="text">FIRSTNAME</text-property>
>                        </label>
>                    </cell>
>                    <cell id="239">
>                        <label id="240">
>                            <text-property name="text">OFFICECODE</text-property>
>                        </label>
>                    </cell>
>                    <cell id="241">
>                        <label id="242">
>                            <text-property name="text">CountColumn</text-property>
>                        </label>
>                    </cell>
>                </row>
>            </header>
>            <group id="261">
>                <property name="groupName">NewTableGroup1</property>
>                <property name="interval">none</property>
>                <property name="sortDirection">asc</property>
>                <expression name="keyExpr">row["OFFICECODE"]</expression>
>                <property name="repeatHeader">true</property>
>                <property name="hideDetail">false</property>
>                <property name="pageBreakAfter">auto</property>
>                <property name="pageBreakBefore">auto</property>
>                <header>
>                    <row id="262">
>                        <cell id="263">
>                            <data id="272">
>                                <property name="resultSetColumn">OFFICECODE</property>
>                            </data>
>                        </cell>
>                        <cell id="264"/>
>                        <cell id="265"/>
>                        <cell id="266"/>
>                    </row>
>                </header>
>                <footer>
>                    <row id="267">
>                        <cell id="268"/>
>                        <cell id="269"/>
>                        <cell id="270"/>
>                        <cell id="271"/>
>                    </row>
>                </footer>
>            </group>
>            <detail>
>                <row id="243">
>                    <cell id="244">
>                        <data id="245">
>                            <property name="resultSetColumn">LASTNAME</property>
>                        </data>
>                    </cell>
>                    <cell id="246">
>                        <data id="247">
>                            <property name="resultSetColumn">FIRSTNAME</property>
>                        </data>
>                    </cell>
>                    <cell id="248">
>                        <data id="249">
>                            <property name="resultSetColumn">OFFICECODE</property>
>                        </data>
>                    </cell>
>                    <cell id="250">
>                        <data id="251">
>                            <property name="resultSetColumn">CountColumn</property>
>                        </data>
>                    </cell>
>                </row>
>            </detail>
>            <footer>
>                <row id="252">
>                    <cell id="253"/>
>                    <cell id="254"/>
>                    <cell id="255"/>
>                    <cell id="256"/>
>                </row>
>            </footer>
>        </table>
>    </body>
></report>

Actions: View

Attachments on bug 173355: 58491