报表中动态变化的区域怎么填充数据
数据源是Json，红框中数据条数会动态变化的，想实现从左到右、从上到下依次填充数据，有什么方法实现？
本帖最后由 Felix.Li 于 2023-5-16 10:18 编辑
waha 发表于 2023-5-15 12:12
json数据:[{"itemCode":"1","itemName":"床位费","amount":1332.00},{"itemCode":"3","itemName":"检查费 ...
这种可以绕一下，使用如下
然后子表格A，隐藏奇数行，B隐藏偶数行，然后嵌套进去:
{IIF(RowNumber() Mod 2 = 1, false, true)}
然后嵌套进去即可
具体可以参考如下报表:
您好，您说的从左到右，从上到下一次填充是什么意思？
是按照您图片上的标识依次展示对应数据吗？如果是这样的话，我看您使用的好像是表头行，您直接绑定这几个字段，就可以展示对应的字段的一个值了。 json数据:[{"itemCode":"1","itemName":"床位费","amount":1332.00},{"itemCode":"3","itemName":"检查费","amount":10326.00},{"itemCode":"4","itemName":"化验费","amount":61},{"itemCode":"2","itemName":"诊查费","amount":0}]
显示效果：
-------------------------------------------------------------------------------
json数据:[{"itemCode":"3","itemName":"检查费","amount":10326.00},{"itemCode":"4","itemName":"化验费","amount":61},{"itemCode":"2","itemName":"诊查费","amount":0}]
显示效果：
---------------------------------------------------------------------------------
json数据:[{"itemCode":"1","itemName":"床位费","amount":1332.00}]
显示效果:
有什么方法实现这些效果？
Eden.Sun 发表于 2023-5-15 08:53
您好，您说的从左到右，从上到下一次填充是什么意思？
是按照您图片上的标识依次展示对应数据吗？如果是这 ...
json数据:[{"itemCode":"1","itemName":"床位费","amount":1332.00},{"itemCode":"3","itemName":"检查费","amount":10326.00},{"itemCode":"4","itemName":"化验费","amount":61},{"itemCode":"2","itemName":"诊查费","amount":0}]
显示效果：
https://gcdn.grapecity.com.cn/data/attachment/forum/202305/15/095426noggvnowagozum9g.png
-------------------------------------------------------------------------------
json数据:[{"itemCode":"3","itemName":"检查费","amount":10326.00},{"itemCode":"4","itemName":"化验费","amount":61},{"itemCode":"2","itemName":"诊查费","amount":0}]
显示效果：
https://gcdn.grapecity.com.cn/data/attachment/forum/202305/15/095817ayw8n8f0qnnj5owf.png
---------------------------------------------------------------------------------
json数据:[{"itemCode":"1","itemName":"床位费","amount":1332.00}]
显示效果:
https://gcdn.grapecity.com.cn/data/attachment/forum/202305/15/100128h3mcuerggkk74kme.png
有什么方法实现这些效果？ Felix.Li 发表于 2023-5-15 12:24
这种可以绕一下，使用如下
然后子表格A，隐藏奇数行，B隐藏偶数行，然后嵌套进去:
json数据:[{"itemCode":"1","itemName":"床位费","amount":0},{"itemCode":"3","itemName":"检查费","amount":2664},{"itemCode":"13","itemName":"血费","amount":0},{"itemCode":"11","itemName":"一般诊疗费","amount":0},{"itemCode":"12","itemName":"其他","amount":0},{"itemCode":"6","itemName":"手术费","amount":0},{"itemCode":"8","itemName":"卫生材料费","amount":2.9},{"itemCode":"10","itemName":"药事服务费","amount":0},{"itemCode":"5","itemName":"治疗费","amount":6.5},{"itemCode":"7","itemName":"护理费","amount":0},{"itemCode":"9","itemName":"药品费","amount":551.83},{"itemCode":"4","itemName":"化验费","amount":61},{"itemCode":"2","itemName":"诊查费","amount":0}]
设置了条件隐藏行，还是没隐藏。
本帖最后由 Eden.Sun 于 2023-5-16 09:31 编辑
waha 发表于 2023-5-16 08:59
json数据:[{"itemCode":"1","itemName":"床位费","amount":0},{"itemCode":"3","itemName":"检查费 ...
您需要把这个隐藏条件加载整个数据行上：
才会根据行号进行隐藏的，您看一下，从您的截图上看，您是不是加在单元格上了：
页:
[1]