[RESOLVED] Data Report doesnt refresh

[enggwaqas]

im using the code given below to generate report, sql query is generated on runtime which saves in string StrSQL...
but the problem is that it generate report for the time and after that during entire application life it will display the same report even though the sql statements are changed, in short active report isnt refreshing???? ne one has the solution?

MsgBox "Click ok to load", vbOKOnly
DataEnvironment1.Commands("Command3").CommandText = strSQL
    
'MsgBox strSQL
DataReport2.Show
Unload Me

thnx in advance

[RhinoBull]

Your title is misleading - "Active Reports" is a product and it is not the same as "Data Report" so you may want to change title's text.

[enggwaqas]

hey thnx god, problem is solved......... added these statements

DataEnvironment1.Recordsets("Command3").Requery
DataReport2.Show

Private Sub DataReport_Terminate()
    DataEnvironment1.Recordsets("Command3").Close
End Sub

[RhinoBull]

hey thnx god, problem is solved

Great! Since it sounds like you resolved it you may want to go back to your original post and from the threads menu select "Resolved...".