On Error Resume Next
' 打印报表
With dtaRpt
Set dtaRpt.DataSource = TestRs
.Sections("section1").Controls.Item("Text1").DataField = TestRs.Fields(0).Name
.Sections("section1").Controls.Item("Text2").DataField = TestRs.Fields(1).Name
.Sections("section1").Controls.Item("Text3").DataField = TestRs.Fields(2).Name
.Sections("section1").Controls.Item("Text4").DataField = TestRs.Fields(3).Name
.Sections("section1").Controls.Item("Text5").DataField = TestRs.Fields(0).Name
.Show
End With
dim db as new adodb.connection
dim rst as new adodb.recordset
此时建立你想要的连接,然后建立你rst
set report.datasource=rst
report.show 1 (report为报表设计器)
再报表窗体上你可以用label,text等等空间任意画注意text要指明是那个字段