销售合同书示例
在报表中您可以添加各种组件来设置模板,本节以销售合同书为例带您快速了解创建分页报表的流程。



1. 数据准备
新增数据源并添加到数据集。
1.1 数据源配置
| 数据源属性 | 属性值 | 
|---|---|
| 数据名 | 销售合同基础信息 | 
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/Basic-information-of-sales-contract | 
| 请求方法 | GET | 
| JSON路径 | $.data[*] | 
JSON数据:
{
    "success": true,
    "code": 200,
    "message": "successful",
    "data": [{
        "id": 1,
        "title": "销售合同书",
        "contract no": "HT20220520001",
        "signing place": "重庆",
        "signing date": "2022-05-20",
        "page footer": "总部地址:成都市双流区广牧路XX号R1-A现代大厦六层 P.C.:518057  FAX:023-66XXXX88\nADD: Floor 6, R1-a modern building, XX, Guangmu Road, Shuangliu District, Chengdu\n全国统一客服热线:400-XXX-XXXX",
        "contract law": "    甲乙双方依据《中华人民共和国合同法》及相关法律法规,本着相互合作、互利互惠的原则,经充分协商,就甲方向乙方购买易流GPS运力搜索引擎系统软件V1.0等事宜达成共识,并形成本合同,甲乙双方共同执行遵守。",
        "party a": "重庆XX有限公司",
        "address of party a": "重庆市九龙坡区科园一街XX号",
        "client of party a": "张三",
        "telephone of party a": "023-68XXX147",
        "fax of party a": "023-68XXX147",
        "postcode of party a": "400000",
        "party b": "成都XX有限公司",
        "address of party b": "成都市双流区广牧路XX号",
        "client of party b": "赵六",
        "telephone of party b": "134XXXXX335",
        "fax of party b": "028-66XXX208",
        "h1-contract subject": "一、合同标的",
        "h1-contract payment": "二、合同付款",
        "h2-purchasing equipment": "1.1、采购设备名称、数量、规格",
        "h2-mode of delivery": "1.2、合同设备交付方式",
        "h2-mode of transport": "1.2.1、运输方式:乙方负责送货上门。",
        "h2-contact information": "1.2.2、送货联系方式:(乙方自带设备安装交付具体见第三条款)",
        "h2-mode of payment": "1.1、采购设备名称、数量、规格",
        "h2-mode of payment for equipment": "2.2、设备款支付方式\n自本合同签订生效之日起,甲方在 5个工作日内支付设备总金额的 75%,即人民币 1000000元整给乙方,余款250000(元)于 2015 年 11 月 30 日前一次性支付给乙方。",
        "h2-payment method of service fee": "2.3、服务费支付方式",
        "h2-pay bills": "2.3.1服务费采取置前(先交费后使用)方式缴纳,即本月支付下个月或下个周期的服务费,每期支付总额以双方确认的对账单为准。",
        "h2-choose the payment method": "2.3.2甲方选择下列任意一种交费方式进行缴纳服务费(甲方在下列选择交费方式前打√):\n本期支付服务费总额为: 100000 元(大写:    万    仟    佰    拾    元    角    分)。",
        "h2-pay on": "2.3.3甲方付款依据:按照乙方提供的缴费周期对账单进行双方确认。甲方自收到乙方对账单之日起    天内回复乙方,否则视为对账无异议。当甲方需要对某具体服务进行临时报停、转网、拆移等异常发生时,应提前通知乙方并履行手续,否则将按照正常收费处理"
    }]
}
注意:数值型数据不要添加双引号。
| 数据源属性 | 属性值 | 
|---|---|
| 数据名 | 销售合同采购信息 | 
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/Interest-rate-for-sales-contract-orders | 
| 请求方法 | GET | 
| JSON路径 | $.data[*] | 
JSON数据:
{
    "success": true,
    "code": 200,
    "message": "successful",
    "data": [{
        "id": 1,
        "device name": "GPS数据信息采集设备",
        "schedule of equipment": "北斗分体机",
        "unit": "台",
        "number": "10",
        "unit price": "20",
        "mounting cost": "100",
        "artificial": "200",
        "sub total": "10020",
        "tatal": "320",
        "service charge": ""
    }, {
        "id": 2,
        "device name": "GPS数据信息采集设备",
        "schedule of equipment": "摄像头-放形",
        "unit": "个",
        "number": "20",
        "unit price": "60",
        "mounting cost": "200",
        "artificial": "300",
        "sub total": "20030",
        "tatal": "560",
        "service charge": ""
    }, {
        "id": 3,
        "device name": "GPS数据信息采集设备",
        "schedule of equipment": "数字温度采集器",
        "unit": "个",
        "number": "30",
        "unit price": "",
        "mounting cost": "",
        "artificial": "",
        "sub total": "",
        "tatal": "",
        "service charge": ""
    }, {
        "id": 4,
        "device name": "GPS数据信息采集设备",
        "schedule of equipment": "数字温度采集器",
        "unit": "个",
        "number": "40",
        "unit price": "87",
        "mounting cost": "233",
        "artificial": "244",
        "sub total": "600",
        "tatal": "235",
        "service charge": ""
    }, {
        "id": 5,
        "device name": "GPS数据信息采集设备",
        "schedule of equipment": "电容油尺",
        "unit": "个",
        "number": "50",
        "unit price": "223",
        "mounting cost": "346",
        "artificial": "345",
        "sub total": "547",
        "tatal": "246",
        "service charge": ""
    }, {
        "id": 6,
        "device name": "GPS数据信息采集设备",
        "schedule of equipment": "设备001",
        "unit": "箱",
        "number": "10",
        "unit price": "300",
        "mounting cost": "533",
        "artificial": "134",
        "sub total": "980",
        "tatal": "540",
        "service charge": ""
    }, {
        "id": 7,
        "device name": "GPS数据信息采集设备",
        "schedule of equipment": "设备002",
        "unit": "盒",
        "number": "35",
        "unit price": "759",
        "mounting cost": "234",
        "artificial": "654",
        "sub total": "2003",
        "tatal": "100",
        "service charge": ""
    }]
}
注意:数值型数据不要添加双引号。
1.2 数据集字段





2. 创建分页报表
2.1 创建分页


2.2 数据绑定

2.3 设置矩表



2.4 设置图片


2.5 设置表格


2.6 设置文本字段



3. 导出Word文档



注意:使用WPS预览导出的Word模板会出现布局上的问题,如果使用Office预览则正常。