就用datareport dim rst as new adodb.recordset dim cnn as new adodb.connection dim sql as string sql="……" rst.Open sql, cnn, adOpenKeyset, adLockPessimistic Set DataEnvironment1.rsCommand1.DataSource = rst Set DataReport1.DataSource = DataEnvironment1 DataReport1.Show
dim comd as adodb.command set comd=new adodb.command 环境对象名.command.item(索引值).commandtext=SQL查询语句 报表名.showcomd 对象变量为报表环境窗口的对象名
dim rst as new adodb.recordset
dim cnn as new adodb.connection
dim sql as string
sql="……"
rst.Open sql, cnn, adOpenKeyset, adLockPessimistic
Set DataEnvironment1.rsCommand1.DataSource = rst
Set DataReport1.DataSource = DataEnvironment1
DataReport1.Show
set comd=new adodb.command
环境对象名.command.item(索引值).commandtext=SQL查询语句
报表名.showcomd 对象变量为报表环境窗口的对象名
Set DataEnvironment1.rsCommand1.DataSource = rst
Set DataReport1.DataSource = DataEnvironment1
DataReport1.Show
没有rsCommand1 属性
如果连接没问题的话
那这一句有错的话也许是sql语句的错吧
我一直就是用的这种方法,没有错啊