加工样品单示例
在报表中您可以添加各种组件来设置模板，本节以加工样品单为例带您快速了解创建分页报表的流程。
1. 数据准备
新增数据源并添加到数据集。
1.1数据源配置
| 数据源属性 | 属性值 |
|---|---|
| 数据名 | 样品单基础信息 |
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/Basic-information-of-sample-list |
| 请求方法 | GET |
| JSON路径 | $.data[*] |
JSON数据：
{
"success": true,
"code": 200,
"message": "successful",
"data": [{
"id": 1,
"title": "xxxx运动品牌成衣加工\n样品单",
"SampleNo": "YP01-16110029",
"template type": "初样",
"customer": "K-ACIT",
"season": "SC36",
"sorting order": "丁一晨",
"product group": "KTMY\nIKCA",
"style no": "F983560",
"sample factory": "美服",
"sample date": "2022/05/23",
"style name": "XXXXX Xx",
"cost center": "MS1生产中心",
"estimated date of delivery": "2022/05/23",
"shell fabric": "65% POLYESTER 35% COTTON PIQUE 250G",
"job requirements": ""
}]
}
注意：数值型数据不要添加双引号。
1.2数据源配置
| 数据源属性 | 属性值 |
|---|---|
| 数据名 | 样品单数量明细表 |
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/quantity-schedule |
| 请求方法 | GET |
| JSON路径 | $.data[*] |
JSON数据：
{
"success": true,
"code": 200,
"message": "successful",
"data": [{
"id": 1,
"color": "#002FA7\n克莱因蓝",
"XS": "0",
"S": "0",
"M": "0",
"L": "0",
"XL": "0",
"2XL": "0",
"3XL": "0",
"4XL": "0"
}, {
"id": 2,
"color": "#66CCCC\n蒂芙尼绿",
"XS": "0",
"S": "0",
"M": "0",
"L": "0",
"XL": "0",
"2XL": "0",
"3XL": "0",
"4XL": "0"
}, {
"id": 3,
"color": "#470024\n勃艮第酒红",
"XS": "0",
"S": "0",
"M": "0",
"L": "0",
"XL": "0",
"2XL": "0",
"3XL": "0",
"4XL": "0"
}, {
"id": 4,
"color": "#6c422c\n可口摩卡",
"XS": "0",
"S": "0",
"M": "0",
"L": "0",
"XL": "0",
"2XL": "0",
"3XL": "0",
"4XL": "0"
}, {
"id": 5,
"color": "#81a3bc\n冰川湖蓝",
"XS": "0",
"S": "0",
"M": "0",
"L": "0",
"XL": "0",
"2XL": "0",
"3XL": "0",
"4XL": "0"
}]
}
注意：数值型数据不要添加双引号。
1.3数据源配置
| 数据源属性 | 属性值 |
|---|---|
| 数据名 | 样品单配色表 |
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/color-table |
| 请求方法 | GET |
| JSON路径 | $.data[*] |
JSON数据：
{
"success": true,
"code": 200,
"message": "successful",
"data": [{
"id": 1,
"space": "前后片、袖子、后领龟背\nPIQ-0000044\n65%涤35%棉单珠地网眼布 250GSM,",
"Yves Klein Blue": "#002FA7\n克莱因蓝",
"Tiffany Green": "#66CCCC\n蒂芙尼绿",
"Burgundy Red": "#470024\n勃艮第酒红",
"Coca Mocha Brown": "#6c422c\n可口摩卡",
"Glacial Lake Blue": "#81a3bc\n冰川湖蓝"
}, {
"id": 2,
"space": "领子和袖克夫\nFLT-0000034\n65/35涤棉1*1横机领",
"Yves Klein Blue": "#002FA7\n克莱因蓝",
"Tiffany Green": "#66CCCC\n蒂芙尼绿",
"Burgundy Red": "#470024\n勃艮第酒红",
"Coca Mocha Brown": "#6c422c\n可口摩卡",
"Glacial Lake Blue": "#81a3bc\n冰川湖蓝"
}, {
"id": 3,
"space": "前中门襟3个，洗标备扣1个\nBTN-0000008\nFAS2070树脂钮扣，18L",
"Yves Klein Blue": "#002FA7\n克莱因蓝",
"Tiffany Green": "#66CCCC\n蒂芙尼绿",
"Burgundy Red": "#470024\n勃艮第酒红",
"Coca Mocha Brown": "#6c422c\n可口摩卡",
"Glacial Lake Blue": "#81a3bc\n冰川湖蓝"
}, {
"id": 4,
"space": "领压条，侧衩压条\nTAP-0000001\n1CM宽 全棉单人字带",
"Yves Klein Blue": "#002FA7\n克莱因蓝",
"Tiffany Green": "#66CCCC\n蒂芙尼绿",
"Burgundy Red": "#470024\n勃艮第酒红",
"Coca Mocha Brown": "#6c422c\n可口摩卡",
"Glacial Lake Blue": "#81a3bc\n冰川湖蓝"
}, {
"id": 5,
"space": "3CM宽 全棉双人字带\nTAP-0000008\n3CM宽 全棉双人字带",
"Yves Klein Blue": "#002FA7\n克莱因蓝",
"Tiffany Green": "#66CCCC\n蒂芙尼绿",
"Burgundy Red": "#470024\n勃艮第酒红",
"Coca Mocha Brown": "#6c422c\n可口摩卡",
"Glacial Lake Blue": "#81a3bc\n冰川湖蓝"
}, {
"id": 6,
"space": "袖克夫\nFLT-0000035\n65/35涤棉1*1横机袖克夫",
"Yves Klein Blue": "#002FA7\n克莱因蓝",
"Tiffany Green": "#66CCCC\n蒂芙尼绿",
"Burgundy Red": "#470024\n勃艮第酒红",
"Coca Mocha Brown": "#6c422c\n可口摩卡",
"Glacial Lake Blue": "#81a3bc\n冰川湖蓝"
}]
}
注意：数值型数据不要添加双引号。
1.4数据源配置
| 数据源属性 | 属性值 |
|---|---|
| 数据名 | 样品单物料BOM明细 |
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/Bom-details-of-materials |
| 请求方法 | GET |
| JSON路径 | $.data[*] |
JSON数据：
{
"success": true,
"code": 200,
"message": "successful",
"data": [{
"id": 1,
"Number": "1",
"Parts/material/commodity names": "前后片、袖子、后领龟背\r\nPIQ-0000044\r\n65%涤35%棉单珠地网眼布 250GSM,",
"Specification/width/remarks": "21S/1T/C65/35单珠地网眼,门幅:200",
"Unit": "M",
"Loss content": "0.75",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "All",
"Material size": "All",
"Remark": ""
}, {
"id": 1,
"Number": "1",
"Parts/material/commodity names": "前后片、袖子、后领龟背\r\nPIQ-0000044\r\n65%涤35%棉单珠地网眼布 250GSM,",
"Specification/width/remarks": "21S/1T/C65/35单珠地网眼,门幅:200",
"Unit": "M",
"Loss content": "0.75",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "All",
"Material size": "All",
"Remark": " "
}, {
"id": 1,
"Number": "1",
"Parts/material/commodity names": "前后片、袖子、后领龟背\r\nPIQ-0000044\r\n65%涤35%棉单珠地网眼布 250GSM,",
"Specification/width/remarks": "21S/1T/C65/35单珠地网眼,门幅:200",
"Unit": "M",
"Loss content": "0.75",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "All",
"Material size": "All",
"Remark": ""
}, {
"id": 2,
"Number": "2",
"Parts/material/commodity names": "穿起左内侧缝，洗标后面\nLBL-0000736\n安全标",
"Specification/width/remarks": "SECURITY LABEL-PENTPFL1-CANTERBURY,",
"Unit": "PCS",
"Loss content": "1.04",
"Color differentiation": "",
"Distinguishing size": "",
"Clothing color": "",
"Material color": "",
"Clothing size": " All ",
"Material size": " All ",
"Remark": " "
}, {
"id": 2,
"Number": "2",
"Parts/material/commodity names": "穿起左内侧缝，洗标后面\nLBL-0000736\n安全标",
"Specification/width/remarks": "SECURITY LABEL-PENTPFL1-CANTERBURY,",
"Unit": "PCS",
"Loss content": "1.04",
"Color differentiation": "",
"Distinguishing size": "",
"Clothing color": "",
"Material color": "",
"Clothing size": " All ",
"Material size": " All ",
"Remark": ""
}, {
"id": 2,
"Number": "2",
"Parts/material/commodity names": "穿起左内侧缝，洗标后面\nLBL-0000736\n安全标",
"Specification/width/remarks": "SECURITY LABEL-PENTPFL1-CANTERBURY,",
"Unit": "PCS",
"Loss content": "1.04",
"Color differentiation": "",
"Distinguishing size": "",
"Clothing color": "",
"Material color": "",
"Clothing size": " All ",
"Material size": " All ",
"Remark": " "
}, {
"id": 3,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "XS",
"Material size": "35CM*3CM",
"Remark": ""
}, {
"id": 4,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "S",
"Material size": "36CM*3CM",
"Remark": " "
}, {
"id": 5,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "M",
"Material size": "37CM*3CM",
"Remark": ""
}, {
"id": 6,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "L",
"Material size": "38CM*3CM",
"Remark": " "
}, {
"id": 7,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "XL",
"Material size": "39CM*3CM",
"Remark": ""
}, {
"id": 8,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "2XL",
"Material size": "40CM*3CM",
"Remark": " "
}, {
"id": 9,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "3XL",
"Material size": "41CM*3CM",
"Remark": ""
}, {
"id": 10,
"Number": "3",
"Parts/material/commodity names": "袖克夫 FLT-0000035 65/35涤棉1*1横机袖克夫",
"Specification/width/remarks": "",
"Unit": " SET ",
"Loss content": "1.05",
"Color differentiation": "Y",
"Distinguishing size": "Y",
"Clothing color": "#002FA7\n克莱因蓝",
"Material color": "#002FA7\n克莱因蓝",
"Clothing size": "4XL",
"Material size": "42CM*3CM",
"Remark": " "
}, {
"id": 11,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "XS",
"Material size": "35CM*3CM",
"Remark": ""
}, {
"id": 12,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "S",
"Material size": "36CM*3CM",
"Remark": " "
}, {
"id": 13,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "M",
"Material size": "37CM*3CM",
"Remark": ""
}, {
"id": 14,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "L",
"Material size": "38CM*3CM",
"Remark": " "
}, {
"id": 15,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "XL",
"Material size": "39CM*3CM",
"Remark": ""
}, {
"id": 16,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "2XL",
"Material size": "40CM*3CM",
"Remark": " "
}, {
"id": 17,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "3XL",
"Material size": "41CM*3CM",
"Remark": ""
}, {
"id": 17,
"Number": "4",
"Parts/material/commodity names": "领子和袖克夫 FLT-0000034 65/35涤棉1*1横机领",
"Specification/width/remarks": " ",
"Unit": " SET",
"Loss content": "1.05 ",
"Color differentiation": " Y ",
"Distinguishing size": " Y ",
"Clothing color": "#81a3bc\n冰川湖蓝",
"Material color": "#81a3bc\n冰川湖蓝",
"Clothing size": "4XL",
"Material size": "42CM*3CM",
"Remark": " "
}]
}
注意：数值型数据不要添加双引号。
1.5数据源配置
| 数据源属性 | 属性值 |
|---|---|
| 数据名 | 样品单二次加工 |
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/fabricating |
| 请求方法 | GET |
| JSON路径 | $.data[*] |
JSON数据：
{
"success": true,
"code": 200,
"message": "successful",
"data": [{
"id": 1,
"Project": "JG0002",
"Project name": "绣花",
"Project description": "EMB 904 CANTERBURY LOWER",
"Site description": "穿起右胸，标准位置",
"Distinguishing color": "Y",
"Distinguishing size": "Y",
"Remark": "",
"Size": "",
"Color": "克莱因蓝",
"Description": "WHITE"
}, {
"id": 2,
"Project": "JG0002",
"Project name": "绣花",
"Project description": "EMB 904 CANTERBURY LOWER",
"Site description": "穿起右胸，标准位置",
"Distinguishing color": "Y",
"Distinguishing size": "Y",
"Remark": "",
"Size": "",
"Color": "蒂芙尼绿",
"Description": "WHITE"
}, {
"id": 3,
"Project": "JG0002",
"Project name": "绣花",
"Project description": "EMB 904 CANTERBURY LOWER",
"Site description": "穿起右胸，标准位置",
"Distinguishing color": "Y",
"Distinguishing size": "Y",
"Remark": "",
"Size": "",
"Color": "勃艮第酒红",
"Description": "WHITE"
}, {
"id": 4,
"Project": "JG0002",
"Project name": "绣花",
"Project description": "EMB 904 CANTERBURY LOWER",
"Site description": "穿起右胸，标准位置",
"Distinguishing color": "Y",
"Distinguishing size": "Y",
"Remark": "",
"Size": "",
"Color": "可口摩卡",
"Description": "WHITE"
}, {
"id": 5,
"Project": "JG0002",
"Project name": "绣花",
"Project description": "EMB 904 CANTERBURY LOWER",
"Site description": "穿起右胸，标准位置",
"Distinguishing color": "Y",
"Distinguishing size": "Y",
"Remark": "",
"Size": "",
"Color": "冰川湖蓝",
"Description": "WHITE"
}]
}
注意：数值型数据不要添加双引号。
2.数据集字段
备注：数据集字段同上。
3. 创建分页报表
3.1 数据绑定
3.2 设置矩表
4. 导出Word文档
注意：使用WPS预览导出的Word模板会出现布局上的问题，如果使用Office预览则正常。