1.控件数据词典:
114303
2.1实际值(公式):SQL("XXX","select id_short from XXX where id_big = "+B3,1,1)
2.3显示值(公式):
SQL("XXX","select shortTableName from XXX where id_big = "+B3,1)
3.不加显示值是这样的:
114306
4.现在下拉控件数据词典加了显示值后,展示出现问题(实际值是XXXid,显示值是XXXname)
:114305
问题:出现1对多,该怎么处理?
谢谢大家,两种方式解决:
方法一:http://help.finereport.com/doc-view-608.html(第一种方法)
方法二:
实际值:SQL("XXX","select id_short from XXX where id_big = "+B3,1)
显示值:SQL("XXX","select shortTableName from XXX where id_big = "+B3+"id_short="+$$$,1,1)(方法二中要注意实际值查询一列数据$$$;显示值查询的是一条数据)
最佳回复,我就按回复时间来采纳了;谢谢大家
编辑于 2018-8-20 10:05
编辑于 2018-8-20 10:06