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



1. 数据准备
新增数据源并添加到数据集。
1.1 数据源配置
| 数据源属性 | 属性值 | 
|---|---|
| 数据名 | 质检报告信息 | 
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/report-information | 
| 请求方法 | GET | 
| JSON路径 | $.data[*] | 
JSON数据:
{
    "success": true,
    "code": 200,
    "message": "successful",
    "data": [{
        "id": 1,
        "Report No": "1501300167",
        "Name of sample": "家用燃气快速热水器",
        "Customer": "西安市质量技术监督局",
        "Inspected entity": "西安市Xx家电商行",
        "Test category": "2017年西安市产品质量安全监控专项监督抽查",
        "Research institute": "陕西省质量检测科学研究院\nShaanxi Academy of Quality Inspection and control",
        "Model grade": "JSD14-C\n合格品",
        "Trademark": "Xx",
        "Date of Manufacture": "/",
        "Serial No": "/",
        "Address": "西安市金东新区1098号",
        "Manufacturer": "西安市Xx电器有限公司",
        "Sampling oraganization": "",
        "Number of samples": "",
        "Sample location": "",
        "Number of samples for inspection": "",
        "Sample Date": "",
        "Receiving number of samples": "",
        "Samples deliver": "",
        "Receiving date of samples": "",
        "Test require": "GB6932-2001《家用燃气快速热水器》、GB20665-2006《家用燃气快速热水器和 热气采暖热水炉能效限定值及能效等级》、GZ396101201 燃气热水器 100-2013 《陕西省燃气热水器产品质量监督检查评价规则》",
        "Test items": "共15项,详见内页。",
        "Description and condition of samples": "外观完好",
        "Test date": "",
        "Test location": "本实验室",
        "Test summary": "依据《陕西省燃气热水器产品质量监督检查评价规则》要求,对所抽样品 的 15 个项目进行了检验,其中“燃烧工况”(C 类)、“热水性能”(A 类)、“使 用说明书”(C 类)、“包装”(C 类)项目的检验结果不符合评价要求。 检验结论:不合格。\r\n                                                     Test Seal\r\n                                                                   批准日期: 2015 年 10 月 23 日 ",
        "Remarks": "受检单位标称生产单位为西安市Xx电器有限公司,标称品牌商为广东Xx空调有限公司;采样日期 2015.9.17",
        "Gas type": "燃气种类:液化石油气(20Y)",
        "Rated gas pressure": "额定燃气压力:2800 Pa",
        "Design heat load": "设计热负荷:14 kW",
        "Rated water capacity": "额定产水能力:7 kg/min",
        "Mounting position": "安装位置:室内",
        "Ignition mode": "点火方式:电子脉冲点火",
        "Applicable water pressure": "适用水压:0.025 MPa~0.8 MPa",
        "Exhaust mode": "排气方式:自然排气式(D 型)",
        "Control mode": "控制方式:/",
        "Energy efficiency rating": "能效等级:2 级",
        "Rated voltage": "额定电压:DC 3.0V",
        "Rated power": "额定电功率:/",
        "Safety device": "安全装置:熄火保护装置、防过热安全装置等",
        "Atmospheric pressure": "大气压力:101.55kPa",
        "Room temperature": "室温:(20~21)℃",
        "Relative humidity": "相对湿度:59%",
        "Low whiteness": "低华白数:75.9 MJ/m3",
        "Notes": "注:所检项目存在下列情况不符合执行标准要求时,判定被监督检查产品的检验结论为“不合格”: ( 1) 有一项或一项以上 A 类不合格项目不符合执行标准要求;( 2) 有二项或二项以上 B 类不合格项目不符合执行标准要求;( 3) 有一项 B 类和二项或二项以上 C 类不合格项目不符合执行标准要求;( 4) 有四项或四项以上 C 类不合格项目不符合执行标准要求;( 5) 产品的使用功能失效。 除上述情况外, 判定被监督检查产品的检验结论为“ 符合本次监督检查要求” 或“ 符合企业标准要求, 不符合国家( 行业、 地方) 标准要求 "
    }]
}
注意:数值型数据不要添加双引号。
| 数据源属性 | 属性值 | 
|---|---|
| 数据名 | 质检报告项目 | 
| Web API地址 | https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/Items-of-quality-inspection-report | 
| 请求方法 | GET | 
| JSON路径 | $.data[*] | 
JSON数据:
{
    "success": true,
    "code": 200,
    "message": "successful",
    "data": [{
        "id": 1,
        "Series number": "1",
        "Test items": "燃气系统气密性",
        "Requirement": "火焰应清晰、均匀",
        "Type": "C",
        "Test Results": "符合",
        "Item conclusion": "不符合"
    }, {
        "id": 1,
        "Series number": "1",
        "Test items": "燃气系统气密性",
        "Requirement": "火焰应清晰、均匀",
        "Type": "C",
        "Test Results": "符合",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "1",
        "Test items": "燃气系统气密性",
        "Requirement": "火焰应清晰、均匀",
        "Type": "A",
        "Test Results": "符合",
        "Item conclusion": "不符合"
    }, {
        "id": 1,
        "Series number": "2",
        "Test items": "热负荷准确度",
        "Requirement": "火焰应清晰、均匀",
        "Type": "A",
        "Test Results": "0.003 L/h",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "2",
        "Test items": "热负荷准确度",
        "Requirement": "火焰应清晰、均匀",
        "Type": "AB",
        "Test Results": "0.002 L/h",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "3",
        "Test items": "燃烧工况",
        "Requirement": "火焰应清晰、均匀",
        "Type": "C",
        "Test Results": "无漏气",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "3",
        "Test items": "燃烧工况",
        "Requirement": "火焰应清晰、均匀",
        "Type": "C",
        "Test Results": "13.5 kW",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "3",
        "Test items": "燃烧工况",
        "Requirement": "火焰应清晰、均匀",
        "Type": "C",
        "Test Results": "-3.6%",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "3",
        "Test items": "燃烧工况",
        "Requirement": "火焰应清晰、均匀",
        "Type": "C",
        "Test Results": "1s,无爆燃",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "3",
        "Test items": "燃烧工况",
        "Requirement": "火焰应清晰、均匀",
        "Type": "B",
        "Test Results": "1s,无爆燃",
        "Item conclusion": "符合"
    }, {
        "id": 1,
        "Series number": "3",
        "Test items": "燃烧工况",
        "Requirement": "火焰应清晰、均匀",
        "Type": "B",
        "Test Results": "符合",
        "Item conclusion": "符合"
    }]
}
注意:数值型数据不要添加双引号。
1.2 数据集字段





2. 创建分页报表


2.1 数据绑定

2.2 设置矩表







3. 导出Word文档

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