Advice on DataEnvironment and DataReport

alexisa · Feb 12, 1999

I have a DE and a DataReport properly attached to a database and the report I designed is properly displayed. However after I close the report screen and return to where the report was called from and want to execute it again or execute a different report I get the error "cannot process this report while the object is open". I take it that this means the DE needs to be closed or refreshed somehow.I have tried different things with no luck. 
Any ideas?? 
Any help will be more than appreciated. 
Thanks 
Alexis

Misled · Feb 26, 1999

The open object is a recordset. Examine the state property of the recordet before executing it. If it is open then close it and rerun report.

FailSafe · Mar 23, 1999

Try this: 
If RS.State = adStateClosed then 
RS.Open 
End If

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Advice on DataEnvironment and DataReport

alexisa

MIS

Misled

Programmer

FailSafe

Programmer

Similar threads

Part and Inventory Search

Sponsor