假如你是用dataenvironment做的数据源 在打开报表前用DataEnvironment1.Connection1.Open 在报表关闭时用Private Sub DataReport_Terminate() Set DataReport1 = Nothing DataEnvironment1.Connection1.Close End Sub 好像还行,试试吧
If DataEnvironment1.rsCommand1.State <> adstateclose Then DataEnvironment1.rsCommand1.Close End if datareport1.Refresh datareport1.Show
On Error Resume Next If DataEnvironment1.rsCommand1.State <> adstateclose Then DataEnvironment1.rsCommand1.Close End if DataEnvironment1.rsCommand1.Open "sql条件语句" Unload 报表名 报表名.Show
If DataEnvironment1.rsCommand1.State <> adStateClosed Then DataEnvironment1.rsCommand1.Close End if DataEnvironment1.rsCommand1.Open "SQL查询语句" Unload 报表名 报表名.Show
在打开报表前用DataEnvironment1.Connection1.Open
在报表关闭时用Private Sub DataReport_Terminate()
Set DataReport1 = Nothing
DataEnvironment1.Connection1.Close
End Sub
好像还行,试试吧
End if
datareport1.Refresh
datareport1.Show
If DataEnvironment1.rsCommand1.State <> adstateclose Then DataEnvironment1.rsCommand1.Close
End if
DataEnvironment1.rsCommand1.Open "sql条件语句"
Unload 报表名
报表名.Show
DataEnvironment1.rsCommand1.Close
End if
DataEnvironment1.rsCommand1.Open "SQL查询语句"
Unload 报表名
报表名.Show