第一部分:为表头配置
第二部分是属性设置
第三部分是属性绑定
第四部分是数据获取
第五部分是数据对应
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.6.0.v201606072122</property>
<list-property name="propertyBindings">
<structure>
<property name="name">JndiName</property>
<property name="id">4</property>
<expression name="value" type="javascript">"java:/jdbc/"+params["p_DATABASE"]+"_"+params["p_SCHEMA"]</expression>
</structure>
<structure>
<property name="name">DriverClass</property>
<property name="id">4</property>
</structure>
<structure>
<property name="name">URL</property>
<property name="id">4</property>
</structure>
<structure>
<property name="name">User</property>
<property name="id">4</property>
</structure>
<structure>
<property name="name">AutoCommit</property>
<property name="id">4</property>
</structure>
<structure>
<property name="name">IsolationMode</property>
<property name="id">4</property>
</structure>
<structure>
<property name="name">Password</property>
<property name="id">4</property>
</structure>
<structure>
<property name="name">ConnProfileName</property>
<property name="id">4</property>
</structure>
<structure>
<property name="name">ConnProfileStorePath</property>
<property name="id">4</property>
</structure>
</list-property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<parameters>
<parameter-group name="OrderGroup" id="416">
<text-property name="promptText" key="PL.OrderGroup"></text-property>
<parameters>
<scalar-parameter name="p_OrdStart" id="325">
<text-property name="promptText" key="PL.From"></text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">0</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="p_OrdEnd" id="326">
<text-property name="promptText" key="PL.To"></text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">ZZZZZZZZZZZZZZZZ</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
</parameter-group>
<scalar-parameter name="p_DATABASE" id="707">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="p_SCHEMA" id="708">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="p_Orders" id="1389">
<property name="hidden">true</property>
<text-property name="promptText">发货单号</text-property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant"></value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="concealValue">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="p_OrdersScreen" id="1140">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">0</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="4">
<list-property name="privateDriverProperties">
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
</list-property>
<property name="DriverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="URL">jdbc:sqlserver://127.0.0.1:1433;databaseName=db</property>
<property name="User">dbaaa1</property>
<encrypted-property name="Password" encryptionID="base64">XXXX</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="DELIVERY_COMMON" id="5">
<list-property name="columnHints"/>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">p_OrdersScreen</property>
<property name="nativeName"></property>
<property name="dataType">integer</property>
<property name="nativeDataType">0</property>
<property name="position">1</property>
<property name="isOptional">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">p_OrdersScreen</property>
<property name="nativeName"></property>
<property name="dataType">integer</property>
<property name="nativeDataType">0</property>
<property name="position">2</property>
<property name="isOptional">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_3</property>
<property name="paramName">p_OrdStart</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">0</property>
<property name="position">3</property>
<property name="isOptional">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_4</property>
<property name="paramName">p_OrdEnd</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">0</property>
<property name="position">4</property>
<property name="isOptional">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">VALUE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">VALUE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">VALUE3</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">VALUE4</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<method name="beforeOpen"><![CDATA[if(params["p_Orders"].value != null)
this.queryText = this.queryText.replace("p_Orders", params["p_Orders"].value);]]></method>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">VALUE1</property>
<property name="nativeName">VALUE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">VALUE2</property>
<property name="nativeName">VALUE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">VALUE3</property>
<property name="nativeName">VALUE3</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">VALUE4</property>
<property name="nativeName">VALUE4</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select
VALUE1,VALUE2,VALUE3,VALUE4
from db
WHERE (( ? = 1 AND t.ORDERKEY IN ('p_Orders' )) OR ( ? = 0 AND t.ORDERKEY BETWEEN ? AND ? ) )]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="delivermethod" id="1468">
<property name="fontSize">20pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">a4</property>
<property name="orientation">portrait</property>
<property name="topMargin">0.08333333333333333in</property>
<property name="leftMargin">0.15625in</property>
<property name="rightMargin">0.11458333333333333in</property>
<property name="height">297mm</property>
<property name="width">210mm</property>
<property name="headerHeight">0.9in</property>
<page-header>
<grid id="1153">
<list-property name="boundDataColumns">
<structure>
<property name="name">time1</property>
<expression name="expression" type="javascript">BirtDateTime.now()</expression>
<property name="dataType">date-time</property>
<property name="allowExport">true</property>
</structure>
</list-property>
<column id="1154">
<property name="width">1.7083333333333333in</property>
</column>
<column id="1155">
<property name="width">1.09375in</property>
</column>
<column id="1156"/>
<column id="1157"/>
<column id="1158"/>
<column id="1159"/>
<row id="1160">
<cell id="1161">
<property name="colSpan">1</property>
<property name="rowSpan">2</property>
<image id="1162">
<property name="height">0.7368421052631579in</property>
<property name="width">1.59375in</property>
<property name="source">file</property>
<expression name="uri" type="constant">report/logo.jpg</expression>
</image>
</cell>
<cell id="1163">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<label id="1164">
<property name="fontSize">16pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text"> AAA 有 限 公 司</text-property>
</label>
</cell>
<cell id="1165">
<property name="verticalAlign">middle</property>
<label id="1166">
<property name="fontSize">9pt</property>
<property name="textAlign">right</property>
<text-property name="text">页码:</text-property>
</label>
</cell>
<cell id="1167">
<property name="verticalAlign">middle</property>
<auto-text id="1168">
<property name="textAlign">left</property>
<property name="type">page-number</property>
</auto-text>
</cell>
</row>
<row id="1169">
<cell id="1170">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<property name="verticalAlign">middle</property>
<label id="1171">
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text"> 面单打印</text-property>
</label>
</cell>
<cell id="1172">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="verticalAlign">middle</property>
<grid id="1173">
<property name="fontSize">9pt</property>
<column id="1174"/>
<column id="1175"/>
<row id="1176">
<cell id="1177">
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
<label id="1178">
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">right</property>
<text-property name="text">SO打印时间:</text-property>
</label>
</cell>
<cell id="1179">
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
<data id="1181">
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">yyyy-MM-dd kk:mm:ss</property>
</structure>
<property name="resultSetColumn">time1</property>
</data>
</cell>
</row>
</grid>
</cell>
</row>
</grid>
</page-header>
</simple-master-page>
</page-setup>
<body>
<table id="1182">
<property name="width">7.989583333333333in</property>
<property name="dataSet">DELIVERY_COMMON</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">WHSEID</property>
<text-property name="displayName">WHSEID</text-property>
<expression name="expression" type="javascript">dataSetRow["WHSEID"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">VALUE1</property>
<text-property name="displayName">VALUE1</text-property>
<expression name="expression" type="javascript">dataSetRow["VALUE1"]</expression>
<property name="dataType">string</property>
<property name="allowExport">true</property>
</structure>
<structure>
<property name="name">VALUE2</property>
<text-property name="displayName">VALUE2</text-property>
<expression name="expression" type="javascript">dataSetRow["VALUE2"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">VALUE3</property>
<text-property name="displayName">VALUE3</text-property>
<expression name="expression" type="javascript">dataSetRow["VALUE3"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">FAX1</property>
<text-property name="displayName">VALUE4</text-property>
<expression name="expression" type="javascript">dataSetRow["VALUE4"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="1216">
<property name="width">0.4270833333333333in</property>
</column>
<column id="1217">
<property name="width">0.7291666666666666in</property>
</column>
<column id="1417">
<property name="width">0.78125in</property>
</column>
<column id="1218">
<property name="width">0.84375in</property>
</column>
<column id="1219">
<property name="width">0.5208333333333334in</property>
</column>
<column id="1220">
<property name="width">0.53125in</property>
</column>
<column id="1221">
<property name="width">0.6041666666666666in</property>
</column>
<column id="1443">
<property name="width">0.5208333333333334in</property>
</column>
<column id="1222">
<property name="width">0.6354166666666666in</property>
</column>
<column id="1223">
<property name="width">0.6145833333333334in</property>
</column>
<column id="1224">
<property name="width">0.6875in</property>
</column>
<column id="1429">
<property name="width">0.6458333333333334in</property>
</column>
<column id="1225">
<property name="width">0.4479166666666667in</property>
</column>
<header>
<row id="1226">
<property name="height">1.84375in</property>
<cell id="1227">
<property name="colSpan">13</property>
<property name="rowSpan">1</property>
<grid id="1237">
<property name="height">3.03125in</property>
<column id="1238">
<property name="width">0.8645833333333334in</property>
</column>
<column id="1239">
<property name="width">1.3125in</property>
</column>
<column id="1240">
<property name="width">1.0208333333333333in</property>
</column>
<column id="1241">
<property name="width">1.2395833333333333in</property>
</column>
<column id="1242">
<property name="width">0.7395833333333334in</property>
</column>
<column id="1243">
<property name="width">0.7395833333333334in</property>
</column>
<row id="1246">
<property name="textAlign">left</property>
<property name="height">0.25in</property>
<cell id="1247">
<label id="1282">
<property name="fontSize">9pt</property>
<text-property name="text">发货仓库:</text-property>
</label>
</cell>
<cell id="1248">
<data id="1295">
<property name="fontSize">9pt</property>
<property name="resultSetColumn">WHSEID</property>
</data>
</cell>
<cell id="1249">
<property name="colSpan">2</property>
<property name="rowSpan">2</property>
<data id="1467">
<property name="style">delivermethod</property>
<property name="resultSetColumn">PRONUMBER</property>
</data>
</cell>
<cell id="1251">
<label id="1291">
<property name="fontSize">9pt</property>
<text-property name="text">发货单号:</text-property>
</label>
</cell>
<cell id="1252">
<data id="1301">
<property name="fontSize">9pt</property>
<property name="resultSetColumn">ORDERKEY</property>
</data>
</cell>
</row>
<row id="1255">
<property name="textAlign">left</property>
<property name="height">0.35in</property>
<cell id="1256">
<label id="1283">
<property name="fontSize">9pt</property>
<text-property name="text">客户名称:</text-property>
</label>
</cell>
<cell id="1257">
<data id="1307">
<property name="fontSize">9pt</property>
<property name="resultSetColumn">COMPANY</property>
</data>
</cell>
<cell id="1260"/>
<cell id="1261"/>
</row>
<row id="1460">
<property name="textAlign">left</property>
<property name="height">0.34375in</property>
<cell id="1461">
<label id="1285">
<property name="fontSize">9pt</property>
<text-property name="text">收货联系人:</text-property>
</label>
</cell>
<cell id="1463">
<label id="1289">
<property name="fontSize">9pt</property>
<text-property name="text">联系方式:</text-property>
</label>
</cell>
<cell id="1464">
<data id="1450">
<property name="resultSetColumn">C_PHONE1</property>
</data>
</cell>
<cell id="1465"/>
<cell id="1466"/>
</row>
<row id="1469">
<property name="textAlign">left</property>
<property name="height">0.3333333333333333in</property>
<cell id="1470">
<label id="1284">
<property name="fontSize">9pt</property>
<text-property name="text">送货地址:</text-property>
</label>
</cell>
<cell id="1471">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<data id="1308">
<property name="fontSize">9pt</property>
<property name="resultSetColumn">C_ADDRESS1</property>
</data>
</cell>
</row>
<row id="1472">
<property name="textAlign">left</property>
<property name="height">0.3125in</property>
<cell id="1473">
<label id="1448">
<property name="fontSize">9pt</property>
<text-property name="text">备注:</text-property>
</label>
</cell>
<cell id="1474">
<property name="colSpan">3</property>
<property name="rowSpan">1</property>
<data id="1447">
<property name="fontWeight">bold</property>
<property name="resultSetColumn">NOTES</property>
</data>
</cell>
<cell id="1477">
<label id="1292">
<property name="fontSize">9pt</property>
<text-property name="text">发货日期:</text-property>
</label>
</cell>
<cell id="1478">
<data id="1300">
<property name="fontSize">9pt</property>
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">YYYY-MM-dd</property>
</structure>
<property name="resultSetColumn">ACTUALSHIPDATE</property>
</data>
</cell>
</row>
</grid>
</cell>
</row>
</header>
</table>
</body>
</report>