Attachment 54303 Details for Bug 165399 – The design flie

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

The design flie

new_report_6.rptdesign (text/xml), 26.77 KB, created by ZhenZhong Fei

on 2006-11-21 21:27:01 EST

(hide)

Description:

Filename:

MIME Type:

Creator: ZhenZhong Fei

Created: 2006-11-21 21:27:01 EST

Size: 26.77 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.v20061120-0710 Build &lt;20061120-0710></property>
>    <property name="units">in</property>
>    <property name="comments">Copyright (c) 2006 &lt;&lt;Your Company Name here>></property>
>    <method name="initialize"><![CDATA[groupBreak="initial";]]></method>
>    <data-sources>
>        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="40">
>            <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="Data Set" id="41">
>            <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">CONTACTLASTNAME</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">4</property>
>                        <property name="name">CONTACTFIRSTNAME</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">5</property>
>                        <property name="name">PHONE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">6</property>
>                        <property name="name">ADDRESSLINE1</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">7</property>
>                        <property name="name">ADDRESSLINE2</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">8</property>
>                        <property name="name">CITY</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">9</property>
>                        <property name="name">STATE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">10</property>
>                        <property name="name">POSTALCODE</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">11</property>
>                        <property name="name">COUNTRY</property>
>                        <property name="dataType">string</property>
>                    </structure>
>                    <structure>
>                        <property name="position">12</property>
>                        <property name="name">SALESREPEMPLOYEENUMBER</property>
>                        <property name="dataType">integer</property>
>                    </structure>
>                    <structure>
>                        <property name="position">13</property>
>                        <property name="name">CREDITLIMIT</property>
>                        <property name="dataType">float</property>
>                    </structure>
>                </list-property>
>            </structure>
>            <property name="dataSource">Data Source</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">CONTACTLASTNAME</property>
>                    <property name="nativeName">CONTACTLASTNAME</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">4</property>
>                    <property name="name">CONTACTFIRSTNAME</property>
>                    <property name="nativeName">CONTACTFIRSTNAME</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">5</property>
>                    <property name="name">PHONE</property>
>                    <property name="nativeName">PHONE</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">6</property>
>                    <property name="name">ADDRESSLINE1</property>
>                    <property name="nativeName">ADDRESSLINE1</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">7</property>
>                    <property name="name">ADDRESSLINE2</property>
>                    <property name="nativeName">ADDRESSLINE2</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">8</property>
>                    <property name="name">CITY</property>
>                    <property name="nativeName">CITY</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">9</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">10</property>
>                    <property name="name">POSTALCODE</property>
>                    <property name="nativeName">POSTALCODE</property>
>                    <property name="dataType">string</property>
>                    <property name="nativeDataType">12</property>
>                </structure>
>                <structure>
>                    <property name="position">11</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">12</property>
>                    <property name="name">SALESREPEMPLOYEENUMBER</property>
>                    <property name="nativeName">SALESREPEMPLOYEENUMBER</property>
>                    <property name="dataType">integer</property>
>                    <property name="nativeDataType">4</property>
>                </structure>
>                <structure>
>                    <property name="position">13</property>
>                    <property name="name">CREDITLIMIT</property>
>                    <property name="nativeName">CREDITLIMIT</property>
>                    <property name="dataType">float</property>
>                    <property name="nativeDataType">8</property>
>                </structure>
>            </list-property>
>            <property name="queryText">select *
>from CLASSICMODELS.CUSTOMERS</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>CUSTOMERNUMBER</design:name>
>            <design:position>1</design:position>
>            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>            <design:precision>10</design:precision>
>            <design:scale>0</design:scale>
>            <design:nullability>Nullable</design:nullability>
>          </design:attributes>
>          <design:usageHints>
>            <design:label>CUSTOMERNUMBER</design:label>
>            <design:formattingHints>
>              <design:displaySize>11</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CUSTOMERNAME</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>CUSTOMERNAME</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CONTACTLASTNAME</design:name>
>            <design:position>3</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>CONTACTLASTNAME</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CONTACTFIRSTNAME</design:name>
>            <design:position>4</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>CONTACTFIRSTNAME</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>PHONE</design:name>
>            <design:position>5</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>PHONE</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>ADDRESSLINE1</design:name>
>            <design:position>6</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>ADDRESSLINE1</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>ADDRESSLINE2</design:name>
>            <design:position>7</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>ADDRESSLINE2</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CITY</design:name>
>            <design:position>8</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>CITY</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>STATE</design:name>
>            <design:position>9</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>STATE</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>POSTALCODE</design:name>
>            <design:position>10</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>            <design:precision>15</design:precision>
>            <design:scale>0</design:scale>
>            <design:nullability>Nullable</design:nullability>
>          </design:attributes>
>          <design:usageHints>
>            <design:label>POSTALCODE</design:label>
>            <design:formattingHints>
>              <design:displaySize>15</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>COUNTRY</design:name>
>            <design:position>11</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>COUNTRY</design:label>
>            <design:formattingHints>
>              <design:displaySize>50</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>SALESREPEMPLOYEENUMBER</design:name>
>            <design:position>12</design:position>
>            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>            <design:precision>10</design:precision>
>            <design:scale>0</design:scale>
>            <design:nullability>Nullable</design:nullability>
>          </design:attributes>
>          <design:usageHints>
>            <design:label>SALESREPEMPLOYEENUMBER</design:label>
>            <design:formattingHints>
>              <design:displaySize>11</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CREDITLIMIT</design:name>
>            <design:position>13</design:position>
>            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>            <design:precision>15</design:precision>
>            <design:scale>0</design:scale>
>            <design:nullability>Nullable</design:nullability>
>          </design:attributes>
>          <design:usageHints>
>            <design:label>CREDITLIMIT</design:label>
>            <design:formattingHints>
>              <design:displaySize>22</design:displaySize>
>            </design:formattingHints>
>          </design:usageHints>
>        </design:resultColumnDefinitions>
>      </design:resultSetColumns>
>    </design:resultSetDefinitions>
>    <design:resultSetDefinitions>
>      <design:resultSetColumns>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CUSTOMERNUMBER</design:name>
>            <design:position>1</design:position>
>            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CUSTOMERNAME</design:name>
>            <design:position>2</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CONTACTLASTNAME</design:name>
>            <design:position>3</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CONTACTFIRSTNAME</design:name>
>            <design:position>4</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>PHONE</design:name>
>            <design:position>5</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>ADDRESSLINE1</design:name>
>            <design:position>6</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>ADDRESSLINE2</design:name>
>            <design:position>7</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CITY</design:name>
>            <design:position>8</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>STATE</design:name>
>            <design:position>9</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>POSTALCODE</design:name>
>            <design:position>10</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>COUNTRY</design:name>
>            <design:position>11</design:position>
>            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>SALESREPEMPLOYEENUMBER</design:name>
>            <design:position>12</design:position>
>            <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>        <design:resultColumnDefinitions>
>          <design:attributes>
>            <design:name>CREDITLIMIT</design:name>
>            <design:position>13</design:position>
>            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
>          </design:attributes>
>        </design:resultColumnDefinitions>
>      </design:resultSetColumns>
>    </design:resultSetDefinitions>
>  </design:ResultSets>
></model:DesignValues>]]></xml-property>
>        </oda-data-set>
>    </data-sets>
>    <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>
>        <list id="42">
>            <property name="dataSet">Data Set</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">CITY</property>
>                    <expression name="expression">dataSetRow["CITY"]</expression>
>                    <property name="dataType">string</property>
>                </structure>
>                <structure>
>                    <property name="name">data item</property>
>                    <expression name="expression">groupBreak</expression>
>                    <property name="dataType">any</property>
>                </structure>
>            </list-property>
>            <method name="onPageBreak"><![CDATA[groupBreak="list group break happens";]]></method>
>            <group id="47">
>                <property name="groupName">NewListGroup1</property>
>                <property name="interval">none</property>
>                <property name="sortDirection">asc</property>
>                <expression name="keyExpr">row["CITY"]</expression>
>                <property name="repeatHeader">false</property>
>                <property name="hideDetail">false</property>
>                <property name="pageBreakAfter">auto</property>
>                <property name="pageBreakBefore">always</property>
>                <header>
>                    <data id="48">
>                        <property name="backgroundColor">#C0C0C0</property>
>                        <property name="resultSetColumn">CITY</property>
>                    </data>
>                </header>
>            </group>
>            <detail>
>                <data id="49">
>                    <property name="resultSetColumn">data item</property>
>                </data>
>                <data id="43">
>                    <property name="resultSetColumn">CUSTOMERNUMBER</property>
>                </data>
>                <data id="46">
>                    <property name="resultSetColumn">CITY</property>
>                </data>
>            </detail>
>        </list>
>    </body>
></report>

Actions: View

Attachments on bug 165399: 54303