rptkan是一个datareport控件, 分页可以了,但datafield的字段是绑定的,我要修改了才能用,怎么取出datafield里具体的值呢?
.Sections("Section1").Controls("text2").DataMember = "mGroup"
.Sections("Section1").Controls("text2").DataField = "dwgr"
这样会每页显示一条记录,可是datareport只有text可以绑定datamember,
但section1上面还有个image1,image1加载的地址就是.Sections("Section1").Controls("text2").DataField = "dwgr"的值,怎么取出值来呢?Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Provider = "MSDataShape"
cn.Open "Data Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source='D:\广西林改系统\ZD.mdb';Persist " _
& "Security Info=False;"
'用SHAPE命令返回分组父子记录集
Sql = "select * from zd where dwgr ='" + nameinmod + "' ORDER BY sfzh, zzwyh"
Sql = "SHAPE {" & Sql & " } " & _
"AS mGroup COMPUTE " & _
"mGroup BY zzwyh "
Set rs = cn.Execute(Sql)
Set rptkan.DataSource = rsWith rptkan
.Sections("section6").ForcePageBreak = 1
.Sections("Section1").Controls("text2").DataMember = "mGroup"
.Sections("Section1").Controls("text2").DataField = "dwgr"
End With
.Sections("Section1").Controls("text2").DataMember = "mGroup"
.Sections("Section1").Controls("text2").DataField = "dwgr"
这样会每页显示一条记录,可是datareport只有text可以绑定datamember,
但section1上面还有个image1,image1加载的地址就是.Sections("Section1").Controls("text2").DataField = "dwgr"的值,怎么取出值来呢?Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Provider = "MSDataShape"
cn.Open "Data Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source='D:\广西林改系统\ZD.mdb';Persist " _
& "Security Info=False;"
'用SHAPE命令返回分组父子记录集
Sql = "select * from zd where dwgr ='" + nameinmod + "' ORDER BY sfzh, zzwyh"
Sql = "SHAPE {" & Sql & " } " & _
"AS mGroup COMPUTE " & _
"mGroup BY zzwyh "
Set rs = cn.Execute(Sql)
Set rptkan.DataSource = rsWith rptkan
.Sections("section6").ForcePageBreak = 1
.Sections("Section1").Controls("text2").DataMember = "mGroup"
.Sections("Section1").Controls("text2").DataField = "dwgr"
End With
With rptkan
.Sections("Section1").Controls("text2").DataMember = "mGroup"
.Sections("Section1").Controls("text2").DataField = "dwgr"
End With
Private Sub DataReport_AsyncProgress(ByVal JobType As MSDataReportLib.AsyncTypeConstants, _
ByVal Cookie As Long, ByVal PageCompleted As Long, _
ByVal TotalPages As Long)
Set Sections("Section1").Controls("Image1").Picture = _
LoadPicture(Sections("Section1").Controls("Text2").Text)
End Sub
据说是datareport的bug