17.1制作分组报表

登录

本帖最后由 waha 于 2023-10-18 18:48 编辑

数据源是JSON格式，想实现图片中效果

数据样例：

[{
"bedNo": "30345-13",
"execBillItemInfos": [{
      "combNo": "64629014",
      "combMark": "┓",
      "doseOnce": "500",
      "doseUnit": "ml",
      "frequencyName": "日一次",
      "inpatientNo": "000000002",
      "itemName": "5%葡萄糖注射液(塑瓶）500ml",
      "useName": "静点"
}, {
      "combNo": "64629014",
      "combMark": "┛",
      "doseOnce": "2",
      "doseUnit": "g",
      "frequencyName": "日一次",
      "inpatientNo": "000000002",
      "itemName": "维生素C注射液",
      "useName": "静点"
}, {
      "combNo": "64629015",
      "combMark": "┓",
      "doseOnce": "500",
      "doseUnit": "ml",
      "frequencyName": "日一次",
      "inpatientNo": "000000002",
      "itemName": "5%葡萄糖注射液(塑瓶）500ml",
      "useName": "续静点"
}, {
      "combNo": "64629015",
      "combMark": "┛",
      "doseOnce": "10",
      "doseUnit": "单位",
      "frequencyName": "日一次",
      "inpatientNo": "000000002",
      "itemName": "缩宫素注射液",
      "useName": "续静点"
}, {
      "combNo": "64629059",
      "combMark": null,
      "doseOnce": "500",
      "doseUnit": "ml",
      "frequencyName": "立即执行",
      "inpatientNo": "000000002",
      "itemName": "复方氯化钠注射液",
      "useName": "续静点"
}, {
      "combNo": "64629062",
      "combMark": "┓",
      "doseOnce": "250",
      "doseUnit": "ml",
      "frequencyName": "立即执行",
      "inpatientNo": "000000002",
      "itemName": "氯化钠注射液(塑瓶)",
      "useName": "续静点"
}, {
      "combNo": "64629062",
      "combMark": "┛",
      "doseOnce": "1.5",
      "doseUnit": "g",
      "frequencyName": "立即执行",
      "inpatientNo": "000000002",
      "itemName": "注射用头孢呋辛钠",
      "useName": "续静点"
}],
"inpatientNo": "000000002",
"name": "刘某某",
"nurseName": "产二科护士站",
"patientNo": "000000004",
"execDate": "2022-08-16",
"printer": "000115",
"shortBedNo": "5-13",
"billName": null
}, {
"bedNo": "30345-16",
"execBillItemInfos": [{
      "combNo": "64627970",
      "combMark": "┓",
      "doseOnce": "500",
      "doseUnit": "ml",
      "frequencyName": "日一次",
      "inpatientNo": "000000001",
      "itemName": "5%葡萄糖注射液(塑瓶）500ml",
      "useName": "续静点"
}, {
      "combNo": "64627970",
      "combMark": "┛",
      "doseOnce": "10",
      "doseUnit": "单位",
      "frequencyName": "日一次",
      "inpatientNo": "000000001",
      "itemName": "缩宫素注射液",
      "useName": "续静点"
}, {
      "combNo": "64627976",
      "combMark": "┓",
      "doseOnce": "1.5",
      "doseUnit": "g",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "注射用头孢呋辛钠",
      "useName": "续静点"
}, {
      "combNo": "64627976",
      "combMark": "┛",
      "doseOnce": "250",
      "doseUnit": "ml",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "氯化钠注射液(塑瓶)",
      "useName": "续静点"
}, {
      "combNo": "64629406",
      "combMark": "┓",
      "doseOnce": "25",
      "doseUnit": "mg",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "****注射液",
      "useName": "肌肉注射"
}, {
      "combNo": "64629406",
      "combMark": "┛",
      "doseOnce": ".05",
      "doseUnit": "g",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "**哌替啶注射液",
      "useName": "肌肉注射"
}, {
      "combNo": "64629407",
      "combMark": "┓",
      "doseOnce": "1",
      "doseUnit": "g",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "葡萄糖酸钙注射液",
      "useName": "续静点"
}, {
      "combNo": "64629407",
      "combMark": "┛",
      "doseOnce": "100",
      "doseUnit": "ml",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "5%葡萄糖注射液",
      "useName": "续静点"
}, {
      "combNo": "64630140",
      "combMark": null,
      "doseOnce": "200",
      "doseUnit": "ml",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "碳酸氢钠注射液",
      "useName": "续静点"
}, {
      "combNo": "64630141",
      "combMark": "┓",
      "doseOnce": "500",
      "doseUnit": "ml",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "5%葡萄糖注射液(塑瓶）500ml",
      "useName": "续静点"
}, {
      "combNo": "64630141",
      "combMark": "┛",
      "doseOnce": "10",
      "doseUnit": "单位",
      "frequencyName": "立即执行",
      "inpatientNo": "000000001",
      "itemName": "缩宫素注射液",
      "useName": "续静点"
}],
"inpatientNo": "000000001",
"name": "马某",
"nurseName": "产二科护士站",
"patientNo": "000000003",
"execDate": "2022-08-16",
"printer": "000115",
"shortBedNo": "5-16",
"billName": null
}]

报表应该怎么实现。

Felix.Li · Felix.Li

如果需要每个都显示自己分组的，就需要用分组头分组尾实现，您可以参考如下报表:

Felix.Li · Felix.Li

问题描述:

主子表报表设计

问题解决:
您可以参考如下教程:
https://gcdn.grapecity.com.cn/fo ... 5&fromuid=59070

如下是我做的Demo，您可以看一下:

waha · waha

Felix.Li 发表于 2023-10-19 11:39
问题描述:

主子表报表设计

第二组数据的头部没有变化，该怎么弄？

waha · waha

本帖最后由 waha 于 2023-10-19 16:58 编辑

Felix.Li 发表于 2023-10-19 14:52
如果需要每个都显示自己分组的，就需要用分组头分组尾实现，您可以参考如下报表:

分组显示可以了。

有这种标记的两组信息中间的横线应该是不显示，相邻信息没有这个标记的是显示横线的，该怎么控制横线的显示和不显示？

Felix.Li · Felix.Li

您可以使用表达式判断，当前和上一个，满足你的条件是，不显示上边线即可:

{IIF(combMark = "┛" And Previous(combMark) = "┓", "None", "Solid")}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] 17.1制作分组报表

最佳答案

5 个回复

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

Wyn高级认证

Wyn认证