Skip to main content

检测报告示例

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

02-01

02-02

02-03

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 数据集字段

02-04

02-05

02-06

02-07

02-08

2. 创建分页报表

02-09

2.1 数据绑定

02-11

2.2 设置矩表

02-12

02-13

02-14

02-15

02-16

02-17

02-18

3. 导出Word文档

02-19

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