此主题相关图片如下:无标题.png
在word报表中,有两个表格,这两个表格的数据可能来自同一张表,也可能来自两张表。表格如何设置,代码如何设置
Dim tm As String = ProjectPath & "Attachments\租赁合同.doc"
Dim fl As String = ProjectPath & "Reports\租赁合同.doc"
Dim wrt As New WordReport(tm,fl)
wrt.AddDataTable("合同信息","1","Sel/ect * from {合同信息} where [_identify]=" & zbt.current("_identify")) '添加父表
wrt.AddDataTable("合同明细","1","Sel/ect * from {合同明细} where 主表id=" & zbt.current("_identify")) '添加子表
wrt.AddRelation("合同信息","_identify","合同明细","主表Id") '建立关联
wrt.Build()
wrt.Show()
[此贴子已经被作者于2022/6/23 15:10:16编辑过]