Set rs = DataEnvironment1.RsTable
If rs.State = adStateOpen Then rs.Close
mysql = "SELECT……" '使用DataEnvironment1.RsTable同样的SQL查询语句
Set conn = DataEnvironment1.Spares
rs.Open mysql, conn, adOpenDynamic, adLockReadOnly
DataReport1.Show
不好意思,有一个错误!!
'---------------------------------
'然后重新组织记录集
With rpt_denv.Commands("cmdreport2")
.CommandText = sql_temp '--sql命令
.Execute
End With
'----------------------------------