-
I have designed a Data report with VB6 designer. Data is added/removed with ADODC. When I go back to enter a new data & try to view the Data Report again, it show previous values only, New entries do not show up in same session unless I close the application & restart it again. What should I do?
I have tried DataReport.Refresh Methodbut it is not working.
-
Each time you view the report it is using the existing data in the data environment.
You will need to unload the data environment after viewing the report. Put the following into the reports QueryClose event. ( Substitute the name of the data environment )
Unload DataEnvironment1
I have tried this and it works.
Alternatively, you may be able to refresh the data environment before viewing the report but I have not tried this so I can't tell you how.