订单表 | 功能展示 | ActiveReportsJS 示例

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>ActiveReportsJS sample</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link
href="https://fonts.googleapis.com/css2?family=Montserrat:ital,wght@0,300;0,400;0,500;0,600;0,700;1,400&display=swap"
rel="stylesheet"
/>
<link
rel="stylesheet"
href="https://cdn.materialdesignicons.com/2.8.94/css/materialdesignicons.min.css"
/>
<script src="/activereportsjs/demos/arjs/dist/ar-js-core.js"></script>
<script src="/activereportsjs/demos/arjs/dist/ar-js-viewer.js"></script>
<script src="/activereportsjs/demos/arjs/dist/ar-js-designer.js"></script>
<script src="/activereportsjs/demos/arjs/dist/ar-js-pdf.js"></script>
<script src="/activereportsjs/demos/arjs/dist/ar-js-html.js"></script>
<script src="/activereportsjs/demos/arjs/dist/ar-js-xlsx.js"></script>
<script src="/activereportsjs/demos/arjs-localization/dist/ar-js-locales.js"></script>
<script src="/activereportsjs/demos/arjs-localization/dist/designer/zh-locale.js"></script>
<script src="$DEMOROOT$/lib/purejs/license.js"></script>
<link
rel="stylesheet"
type="text/css"
href="/activereportsjs/demos/arjs/styles/ar-js-ui.css"
/>
<link
rel="stylesheet"
type="text/css"
href="/activereportsjs/demos/arjs/styles/ar-js-viewer.css"
/>
<link
rel="stylesheet"
type="text/css"
href="/activereportsjs/demos/arjs/styles/ar-js-designer.css"
/>
<style>
#root {
height: 100vh;
}
#viewer-host,
#designer-host {
height: 100%;
}
#designer-host {
display: none;
}
</style>
</head>
<body onload="load()" style="margin: 0">
<div id="root">
<div id="viewer-host"></div>
<div id="designer-host"></div>
</div>
<script>
var currentReport = undefined;
var viewerHost = document.getElementById("viewer-host");
var designerHost = document.getElementById("designer-host");
function load() {
var viewer = new ActiveReports.Viewer("#viewer-host", {
language: "zh",
});
var designer = new GC.ActiveReports.ReportDesigner.Designer(
"#designer-host",
{ language: "zh" }
);
designer.setActionHandlers({
onRender(report) {
currentReport = report.definition;
viewer.open(currentReport);
viewerHost.style.display = "block";
designerHost.style.display = "none";
// return Promise.resolve();
},
});
var designButton = {
key: "$openDesigner",
text: "编辑报表",
iconCssClass: "mdi mdi-pencil",
enabled: true,
action: function (item) {
designer.setReport({
definition: currentReport,
displayName: "订单表",
});
viewerHost.style.display = "none";
designerHost.style.display = "block";
},
};
viewer.toolbar.addItem(designButton);
viewer.toolbar.updateLayout({
default: [
"$openDesigner",
"$split",
"$navigation",
"$split",
"$refresh",
"$split",
"$history",
"$split",
"$zoom",
"$fullscreen",
"$split",
"$print",
"$split",
"$singlepagemode",
"$continuousmode",
"$galleymode",
],
});
fetch("dingdanbiao.rdlx-json")
.then(function (data) {
return data.json();
})
.then(function (report) {
currentReport = report;
viewer.open(report);
});
}
</script>
</body>
</html>

{"Name":"Report","Width":"8.5in","Layers":[{"Name":"default"}],"CustomProperties":[{"Name":"DisplayType","Value":"Page"},{"Name":"SizeType","Value":"Default"},{"Name":"PaperOrientation","Value":"Portrait"}],"Page":{"PageWidth":"8.5in","PageHeight":"11in","RightMargin":"0.25cm","LeftMargin":"0.25cm","TopMargin":"0.25cm","BottomMargin":"0.25cm","Columns":1,"ColumnSpacing":"0in"},"DataSources":[{"Name":"本地测试数据","ConnectionProperties":{"DataProvider":"JSONEMBED","ConnectString":"jsondata={\\n    \"code\": 200000,\\n    \"message\": null,\\n    \"data\": [\\n        {\\n            \"orderNo\": \"OM21042600000051\",\\n            \"sapSubCusName\": \"省直幼儿园（北大）\",\\n            \"sapCusName\": \"**省直属机关幼儿园\",\\n            \"sapCusCode\": \"100360\",\\n            \"merchantName\": \"*辉超市股份有限公司\",\\n            \"orderTime\": \"2021-04-26 12:25:45\",\\n            \"requireDeliveryTime\": \"2021-04-29 00:00-23:59\",\\n            \"preferDcName\": \"福建企业购\",\\n            \"receiveUsername\": \"13000000000\",\\n            \"receivePhone\": \"13000000000\",\\n            \"custCon\": \"**省直属机关幼儿园\",\\n            \"conTel\": \"13000000000\",\\n            \"contactPerson\": \"托亚135\",\\n            \"phone\": \"13000000000\",\\n            \"receiveAddr\": \"\",\\n            \"pageNum\": \"1\",\\n            \"totalNum\": \"1\",\\n            \"sum\": \"139.6\",\\n            \"sumTraditional\": \"壹佰叁拾玖元陆角\",\\n            \"totalSum\": \"139.6\",\\n            \"totalSumTraditional\": \"壹佰叁拾玖元陆角\",\\n            \"buyerRemarks\": null,\\n            \"realTotalPriceWithoutTax\": \"128.07\",\\n            \"taxTotalPrice\": \"11.53\",\\n            \"realTotalPrice\": \"139.6\",\\n            \"orderItems\": [\\n                {\\n                    \"sortNum\": 1,\\n                    \"productCode\": \"1\",\\n                    \"productBarcode\": \"2304348000004\",\\n                    \"productName\": \"花生\",\\n                    \"productNameWithBuyerRemark\": \"花生\",\\n                    \"unit\": \"KG\",\\n                    \"originPrice\": \"13.96\",\\n                    \"originAmount\": \"139.6\",\\n                    \"promotionPrice\": \"13.96\",\\n                    \"sendQty\": \"10\",\\n                    \"realTotalPrice\": \"139.6\",\\n                    \"promotionPriceWithoutTax\": \"12.8073\",\\n                    \"realTotalPriceWithoutTax\": \"128.07\",\\n                    \"taxRatePercent\": \"9%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"11.53\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"10\",\\n                    \"purchaseUnit\": \"KG\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"花生\"\\n                }\\n            ],\\n            \"tms\": \"是\",\\n            \"externalOrderCode\": \"OM21042600000051\",\\n            \"deliverAreaCode\": \"1\",\\n            \"originSum\": \"139.6\",\\n            \"title\": \"**省直属机关幼儿园\"\\n        },\\n        {\\n            \"orderNo\": \"OM21042600000104\",\\n            \"sapSubCusName\": \"省直幼儿园（北大）\",\\n            \"sapCusName\": \"**省直属机关幼儿园\",\\n            \"sapCusCode\": \"100360\",\\n            \"merchantName\": \"*辉超市股份有限公司\",\\n            \"orderTime\": \"2021-04-26 17:22:47\",\\n            \"requireDeliveryTime\": \"2021-04-29 00:00-23:59\",\\n            \"preferDcName\": \"福建企业购\",\\n            \"receiveUsername\": \"13000000000\",\\n            \"receivePhone\": \"13000000000\",\\n            \"custCon\": \"**省直属机关幼儿园\",\\n            \"conTel\": \"13000000000\",\\n            \"contactPerson\": \"托亚135\",\\n            \"phone\": \"13000000000\",\\n            \"receiveAddr\": \"\",\\n            \"pageNum\": \"1\",\\n            \"totalNum\": \"1\",\\n            \"sum\": \"189.6\",\\n            \"sumTraditional\": \"壹佰捌拾玖元陆角\",\\n            \"totalSum\": \"189.6\",\\n            \"totalSumTraditional\": \"壹佰捌拾玖元陆角\",\\n            \"buyerRemarks\": null,\\n            \"realTotalPriceWithoutTax\": \"172.32\",\\n            \"taxTotalPrice\": \"17.28\",\\n            \"realTotalPrice\": \"189.6\",\\n            \"orderItems\": [\\n                {\\n                    \"sortNum\": 1,\\n                    \"productCode\": \"1\",\\n                    \"productBarcode\": \"2304348000004\",\\n                    \"productName\": \"花生\",\\n                    \"productNameWithBuyerRemark\": \"花生\",\\n                    \"unit\": \"KG\",\\n                    \"originPrice\": \"13.96\",\\n                    \"originAmount\": \"139.6\",\\n                    \"promotionPrice\": \"13.96\",\\n                    \"sendQty\": \"10\",\\n                    \"realTotalPrice\": \"139.6\",\\n                    \"promotionPriceWithoutTax\": \"12.8073\",\\n                    \"realTotalPriceWithoutTax\": \"128.07\",\\n                    \"taxRatePercent\": \"9%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"11.53\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"10\",\\n                    \"purchaseUnit\": \"KG\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"花生\"\\n                },\\n                {\\n                    \"sortNum\": 2,\\n                    \"productCode\": \"6889\",\\n                    \"productBarcode\": \"6901028048125\",\\n                    \"productName\": \"红梅（15mg软黄）包\",\\n                    \"productNameWithBuyerRemark\": \"红梅（15mg软黄）包\",\\n                    \"unit\": \"包\",\\n                    \"originPrice\": \"5\",\\n                    \"originAmount\": \"50\",\\n                    \"promotionPrice\": \"5\",\\n                    \"sendQty\": \"10\",\\n                    \"realTotalPrice\": \"50\",\\n                    \"promotionPriceWithoutTax\": \"4.4248\",\\n                    \"realTotalPriceWithoutTax\": \"44.25\",\\n                    \"taxRatePercent\": \"13%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"5.75\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"10\",\\n                    \"purchaseUnit\": \"包\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"红梅（15mg软黄）包\"\\n                }\\n            ],\\n            \"tms\": \"是\",\\n            \"externalOrderCode\": \"OM21042600000104\",\\n            \"deliverAreaCode\": \"1\",\\n            \"originSum\": \"189.6\",\\n            \"title\": \"**省直属机关幼儿园\"\\n        },\\n        {\\n            \"orderNo\": \"OM21042600000079\",\\n            \"sapSubCusName\": \"省直幼儿园（北大）\",\\n            \"sapCusName\": \"**省直属机关幼儿园\",\\n            \"sapCusCode\": \"100360\",\\n            \"merchantName\": \"*辉超市股份有限公司\",\\n            \"orderTime\": \"2021-04-26 15:06:46\",\\n            \"requireDeliveryTime\": \"2021-04-27 00:00-23:59\",\\n            \"preferDcName\": \"福建企业购\",\\n            \"receiveUsername\": \"13000000000\",\\n            \"receivePhone\": \"13000000000\",\\n            \"custCon\": \"**省直属机关幼儿园\",\\n            \"conTel\": \"13000000000\",\\n            \"contactPerson\": \"托亚135\",\\n            \"phone\": \"13000000000\",\\n            \"receiveAddr\": \"\",\\n            \"pageNum\": \"1\",\\n            \"totalNum\": \"1\",\\n            \"sum\": \"14335.67\",\\n            \"sumTraditional\": \"壹万肆仟叁佰叁拾伍元陆角柒分\",\\n            \"totalSum\": \"14335.67\",\\n            \"totalSumTraditional\": \"壹万肆仟叁佰叁拾伍元陆角柒分\",\\n            \"buyerRemarks\": null,\\n            \"realTotalPriceWithoutTax\": \"12898.17\",\\n            \"taxTotalPrice\": \"1437.5\",\\n            \"realTotalPrice\": \"14335.67\",\\n            \"orderItems\": [\\n                {\\n                    \"sortNum\": 1,\\n                    \"productCode\": \"3\",\\n                    \"productBarcode\": \"2302770000005\",\\n                    \"productName\": \"东北绿豆\",\\n                    \"productNameWithBuyerRemark\": \"东北绿豆\",\\n                    \"unit\": \"KG\",\\n                    \"originPrice\": \"9.98\",\\n                    \"originAmount\": \"507.78\",\\n                    \"promotionPrice\": \"9.98\",\\n                    \"sendQty\": \"50.88\",\\n                    \"realTotalPrice\": \"507.78\",\\n                    \"promotionPriceWithoutTax\": \"9.156\",\\n                    \"realTotalPriceWithoutTax\": \"465.85\",\\n                    \"taxRatePercent\": \"9%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"6.93\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"50.88\",\\n                    \"purchaseUnit\": \"KG\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"测试东北绿豆\"\\n                },\\n                {\\n                    \"sortNum\": 2,\\n                    \"productCode\": \"8774\",\\n                    \"productBarcode\": \"2302972000001\",\\n                    \"productName\": \"鸭蛋\",\\n                    \"productNameWithBuyerRemark\": \"鸭蛋\",\\n                    \"unit\": \"KG\",\\n                    \"originPrice\": \"13.16\",\\n                    \"originAmount\": \"1434.31\",\\n                    \"promotionPrice\": \"13.16\",\\n                    \"sendQty\": \"108.99\",\\n                    \"realTotalPrice\": \"1434.31\",\\n                    \"promotionPriceWithoutTax\": \"13.16\",\\n                    \"realTotalPriceWithoutTax\": \"1434.31\",\\n                    \"taxRatePercent\": \"0%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"8.86\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"108.99\",\\n                    \"purchaseUnit\": \"KG\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"测试鸭蛋\"\\n                },\\n                {\\n                    \"sortNum\": 3,\\n                    \"productCode\": \"1042915\",\\n                    \"productBarcode\": \"6927690331969\",\\n                    \"productName\": \"田趣小町米5kg\",\\n                    \"productNameWithBuyerRemark\": \"田趣小町米5kg\",\\n                    \"unit\": \"包\",\\n                    \"originPrice\": \"46.8\",\\n                    \"originAmount\": \"889.2\",\\n                    \"promotionPrice\": \"46.8\",\\n                    \"sendQty\": \"19\",\\n                    \"realTotalPrice\": \"889.2\",\\n                    \"promotionPriceWithoutTax\": \"42.9358\",\\n                    \"realTotalPriceWithoutTax\": \"815.78\",\\n                    \"taxRatePercent\": \"9%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"33.42\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"19\",\\n                    \"purchaseUnit\": \"包\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"田趣小町米5kg\"\\n                },\\n                {\\n                    \"sortNum\": 4,\\n                    \"productCode\": \"1\",\\n                    \"productBarcode\": \"2304348000004\",\\n                    \"productName\": \"花生\",\\n                    \"productNameWithBuyerRemark\": \"花生\",\\n                    \"unit\": \"KG\",\\n                    \"originPrice\": \"13.96\",\\n                    \"originAmount\": \"41.88\",\\n                    \"promotionPrice\": \"13.96\",\\n                    \"sendQty\": \"3\",\\n                    \"realTotalPrice\": \"41.88\",\\n                    \"promotionPriceWithoutTax\": \"12.8073\",\\n                    \"realTotalPriceWithoutTax\": \"38.42\",\\n                    \"taxRatePercent\": \"9%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"3.46\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"3\",\\n                    \"purchaseUnit\": \"KG\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"花生\"\\n                },\\n                {\\n                    \"sortNum\": 5,\\n                    \"productCode\": \"6939\",\\n                    \"productBarcode\": \"6901434382882\",\\n                    \"productName\": \"剑南春52度白酒500ml\",\\n                    \"productNameWithBuyerRemark\": \"剑南春52度白酒500ml\",\\n                    \"unit\": \"瓶\",\\n                    \"originPrice\": \"489\",\\n                    \"originAmount\": \"9780\",\\n                    \"promotionPrice\": \"500\",\\n                    \"sendQty\": \"20\",\\n                    \"realTotalPrice\": \"10000\",\\n                    \"promotionPriceWithoutTax\": \"442.4779\",\\n                    \"realTotalPriceWithoutTax\": \"8849.56\",\\n                    \"taxRatePercent\": \"13%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"150.44\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"20\",\\n                    \"purchaseUnit\": \"瓶\",\\n                    \"discountRate\": \"102\",\\n                    \"customerProductName\": \"剑南春52度白酒500ml\"\\n                },\\n                {\\n                    \"sortNum\": 6,\\n                    \"productCode\": \"6882\",\\n                    \"productBarcode\": \"6901028118170\",\\n                    \"productName\": \"利群（红新版）包\",\\n                    \"productNameWithBuyerRemark\": \"利群（红新版）包\",\\n                    \"unit\": \"包\",\\n                    \"originPrice\": \"15\",\\n                    \"originAmount\": \"825\",\\n                    \"promotionPrice\": \"15\",\\n                    \"sendQty\": \"55\",\\n                    \"realTotalPrice\": \"825\",\\n                    \"promotionPriceWithoutTax\": \"13.2743\",\\n                    \"realTotalPriceWithoutTax\": \"730.09\",\\n                    \"taxRatePercent\": \"13%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"11.91\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"55\",\\n                    \"purchaseUnit\": \"包\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"1111111\"\\n                },\\n                {\\n                    \"sortNum\": 7,\\n                    \"productCode\": \"233223\",\\n                    \"productBarcode\": \"6917878027883\",\\n                    \"productName\": \"雀巢怡运全脂高钙奶粉400g\",\\n                    \"productNameWithBuyerRemark\": \"雀巢怡运全脂高钙奶粉400g\",\\n                    \"unit\": \"400g/袋\",\\n                    \"originPrice\": \"42.5\",\\n                    \"originAmount\": \"637.5\",\\n                    \"promotionPrice\": \"42.5\",\\n                    \"sendQty\": \"15\",\\n                    \"realTotalPrice\": \"637.5\",\\n                    \"promotionPriceWithoutTax\": \"37.6106\",\\n                    \"realTotalPriceWithoutTax\": \"564.16\",\\n                    \"taxRatePercent\": \"13%\",\\n                    \"buyerRemarks\": \"\",\\n                    \"taxPrice\": \"33.34\",\\n                    \"departConfirm\": null,\\n                    \"wasteRate\": null,\\n                    \"manufactureFactory\": null,\\n                    \"manufactureDate\": null,\\n                    \"expirationDate\": null,\\n                    \"other\": null,\\n                    \"specRemarks\": \"\",\\n                    \"brandName\": null,\\n                    \"purchaseQty\": \"15\",\\n                    \"purchaseUnit\": \"400g/袋\",\\n                    \"discountRate\": \"100\",\\n                    \"customerProductName\": \"测试雀巢\"\\n                }\\n            ],\\n            \"tms\": \"是\",\\n            \"externalOrderCode\": \"OM21042600000079\",\\n            \"deliverAreaCode\": \"2\",\\n            \"originSum\": \"14115.67\",\\n            \"title\": \"**省直属机关幼儿园\"\\n        }\\n    ]\\n}"}}],"FixedPage":{"Pages":[{"ReportItems":[{"Type":"barcode","Name":"条形码1","ZIndex":1,"Value":"=Fields!sapCusCode.Value","Symbology":"QRCode","QuietZone":{"Left":"0cm","Right":"0cm","Top":"0cm","Bottom":"0cm"},"SupplementOptions":{"Spacing":"0cm"},"Style":{"FontFamily":"微软雅黑","TextAlign":"Right"},"Left":"18.425cm","Top":"0.499cm","Width":"2cm","Height":"2.001cm"},{"Type":"barcode","Name":"条形码2","ZIndex":2,"Value":"=Fields!externalOrderCode.Value","Symbology":"Code_128auto","QuietZone":{"Left":"0cm","Right":"0cm","Top":"0cm","Bottom":"0cm"},"SupplementOptions":{"Spacing":"0cm"},"Style":{"FontFamily":"微软雅黑","TextAlign":"Left"},"Left":"0cm","Top":"0.998cm","Width":"4cm","Height":"1.001cm"},{"Type":"table","Name":"表格2","ZIndex":9,"DataSetName":"DataSet","Style":{"FontFamily":"微软雅黑"},"TableColumns":[{"Width":"5.301cm"},{"Width":"4.035cm"},{"Width":"4.465cm"},{"Width":"6.501cm"}],"TableGroups":[{"Group":{"Name":"表格2_表格分组1","GroupExpressions":[""]},"Footer":{"TableRows":[{"Height":"2.251cm","TableCells":[{"Item":{"Type":"rectangle","Name":"容器1","ConsumeWhiteSpace":true,"Style":{"Border":{"Color":"DimGray","Style":"Solid"}},"ReportItems":[{"Type":"table","Name":"表格3","DataSetName":"orderItems","Style":{"FontFamily":"微软雅黑"},"TableColumns":[{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.802cm"},{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.5cm"}],"Header":{"TableRows":[{"Height":"0.85cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框39","KeepTogether":true,"Value":"序号","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框48","KeepTogether":true,"Value":"商品编码","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框49","KeepTogether":true,"Value":" 商品名称","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.802cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框50","KeepTogether":true,"Value":"单位","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框57","KeepTogether":true,"Value":"售价","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框60","KeepTogether":true,"Value":"团购价","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框63","KeepTogether":true,"Value":"发货数量","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框66","KeepTogether":true,"Value":"总金额","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}}]}],"RepeatOnNewPage":true},"Details":{"TableRows":[{"Height":"0.85cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框40","KeepTogether":true,"Value":"=RowNumber()","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框51","DataElementName":"productCode","KeepTogether":true,"Value":"=Fields!productCode.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框52","DataElementName":"productName","CanGrow":true,"KeepTogether":true,"Value":"=Fields!productName.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","ShrinkToFit":"=True"},"Left":"0cm","Top":"0cm","Width":"2.802cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框53","DataElementName":"unit","KeepTogether":true,"Value":"=Fields!unit.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框58","DataElementName":"originPrice","KeepTogether":true,"Value":"=Fields!originPrice.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框61","DataElementName":"taxPrice","KeepTogether":true,"Value":"=Fields!taxPrice.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框64","DataElementName":"purchaseQty","KeepTogether":true,"Value":"=Fields!purchaseQty.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框67","KeepTogether":true,"Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}}]}]},"Left":"0cm","Top":"0cm","Width":"20.302cm","Height":"1.7cm"}],"Left":"0cm","Top":"0cm","Width":"20.302cm","Height":"2.251cm"},"ColSpan":4},null,null,null]}]}}],"Footer":{"TableRows":[{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框36","KeepTogether":true,"Value":"=\"合计金额（大写）：\" + Fields!sumTraditional.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"9.336cm","Height":"0.75cm"},"ColSpan":2},null,{"Item":{"Type":"textbox","Name":"文本框38","DataElementName":"sum","KeepTogether":true,"Value":"=Sum(Fields!sum.Value)","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"10.966cm","Height":"0.75cm"},"ColSpan":2},null]},{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框33","KeepTogether":true,"Value":"=\"合计总金额（大写）:\" + Fields!totalSumTraditional.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"9.336cm","Height":"0.75cm"},"ColSpan":2},null,{"Item":{"Type":"textbox","Name":"文本框42","DataElementName":"totalSum","KeepTogether":true,"Value":"=Sum(Fields!totalSum.Value)","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"10.966cm","Height":"0.75cm"},"ColSpan":2},null]},{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框37","KeepTogether":true,"Value":"出货仓管确认签字：","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"5.301cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框44","KeepTogether":true,"Value":"承运方确认签字：","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"8.5cm","Height":"0.75cm"},"ColSpan":2},null,{"Item":{"Type":"textbox","Name":"文本框47","KeepTogether":true,"Value":"客户确认签字：","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"6.501cm","Height":"0.75cm"}}]}]},"Left":"0.2cm","Top":"5.259cm","Width":"20.302cm","Height":"4.501cm","FixedWidth":"20.301cm","FixedHeight":"11.241cm"},{"Type":"textbox","Name":"文本框19","ZIndex":10,"KeepTogether":true,"Value":"  =\"客户订货时间：\"+Fields!orderTime.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0.2cm","Top":"4.518cm","Width":"10.233cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框22","ZIndex":11,"KeepTogether":true,"Value":"=\"客户信息：\"+Fields!sapSubCusName.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0.2cm","Top":"3.759cm","Width":"10.232cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框23","ZIndex":12,"KeepTogether":true,"Value":"  =\"客户提货时间：\"+Fields!requireDeliveryTime.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"10.432cm","Top":"4.509cm","Width":"10cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框31","ZIndex":13,"KeepTogether":true,"Value":"  =\"出货门店：\"+Fields!merchantName.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"10.432cm","Top":"3.771cm","Width":"10cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框32","ZIndex":14,"KeepTogether":true,"Value":"  =Fields!title.Value + \"团购订单\"","Style":{"FontFamily":"微软雅黑","FontWeight":"Bold","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center"},"Left":"0.2cm","Top":"3.01cm","Width":"20.232cm","Height":"0.75cm"}]}],"Group":{"Name":"固定页面_分组1","GroupExpressions":["=Fields!orderNo.Value"]},"DataSetName":"DataSet"},"DataSets":[{"Name":"DataSet","Fields":[{"Name":"orderNo","DataField":"orderNo"},{"Name":"sapSubCusName","DataField":"sapSubCusName"},{"Name":"sapCusName","DataField":"sapCusName"},{"Name":"sapCusCode","DataField":"sapCusCode"},{"Name":"merchantName","DataField":"merchantName"},{"Name":"orderTime","DataField":"orderTime"},{"Name":"requireDeliveryTime","DataField":"requireDeliveryTime"},{"Name":"preferDcName","DataField":"preferDcName"},{"Name":"receiveUsername","DataField":"receiveUsername"},{"Name":"receivePhone","DataField":"receivePhone"},{"Name":"custCon","DataField":"custCon"},{"Name":"conTel","DataField":"conTel"},{"Name":"contactPerson","DataField":"contactPerson"},{"Name":"phone","DataField":"phone"},{"Name":"receiveAddr","DataField":"receiveAddr"},{"Name":"pageNum","DataField":"pageNum"},{"Name":"totalNum","DataField":"totalNum"},{"Name":"sum","DataField":"sum"},{"Name":"sumTraditional","DataField":"sumTraditional"},{"Name":"totalSum","DataField":"totalSum"},{"Name":"totalSumTraditional","DataField":"totalSumTraditional"},{"Name":"buyerRemarks","DataField":"buyerRemarks"},{"Name":"realTotalPriceWithoutTax","DataField":"realTotalPriceWithoutTax"},{"Name":"taxTotalPrice","DataField":"taxTotalPrice"},{"Name":"realTotalPrice","DataField":"realTotalPrice"},{"Name":"orderItems","DataField":"orderItems"},{"Name":"tms","DataField":"tms"},{"Name":"externalOrderCode","DataField":"externalOrderCode"},{"Name":"deliverAreaCode","DataField":"deliverAreaCode"},{"Name":"originSum","DataField":"originSum"},{"Name":"title","DataField":"title"}],"Query":{"DataSourceName":"本地测试数据","CommandText":"jpath=$.data.*"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"},{"Name":"orderItems","Fields":[{"Name":"sortNum","DataField":"sortNum"},{"Name":"productCode","DataField":"productCode"},{"Name":"productBarcode","DataField":"productBarcode"},{"Name":"productName","DataField":"productName"},{"Name":"productNameWithBuyerRemark","DataField":"productNameWithBuyerRemark"},{"Name":"unit","DataField":"unit"},{"Name":"originPrice","DataField":"originPrice"},{"Name":"originAmount","DataField":"originAmount"},{"Name":"promotionPrice","DataField":"promotionPrice"},{"Name":"sendQty","DataField":"sendQty"},{"Name":"realTotalPrice","DataField":"realTotalPrice"},{"Name":"promotionPriceWithoutTax","DataField":"promotionPriceWithoutTax"},{"Name":"realTotalPriceWithoutTax","DataField":"realTotalPriceWithoutTax"},{"Name":"taxRatePercent","DataField":"taxRatePercent"},{"Name":"buyerRemarks","DataField":"buyerRemarks"},{"Name":"taxPrice","DataField":"taxPrice"},{"Name":"departConfirm","DataField":"departConfirm"},{"Name":"wasteRate","DataField":"wasteRate"},{"Name":"manufactureFactory","DataField":"manufactureFactory"},{"Name":"manufactureDate","DataField":"manufactureDate"},{"Name":"expirationDate","DataField":"expirationDate"},{"Name":"other","DataField":"other"},{"Name":"specRemarks","DataField":"specRemarks"},{"Name":"brandName","DataField":"brandName"},{"Name":"purchaseQty","DataField":"purchaseQty"},{"Name":"purchaseUnit","DataField":"purchaseUnit"},{"Name":"discountRate","DataField":"discountRate"},{"Name":"customerProductName","DataField":"customerProductName"}],"Query":{"DataSourceName":"$dataset:DataSet/orderItems"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"}]}