[RESOLVED] Data Report doesnt refresh

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?

VB Code:

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

thnx in advance

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.

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

VB Code:

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

VB Code:

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

Quote:

---

Originally Posted by enggwaqas

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...".