Hi,

I created an Access File, from which I want to make a DataReport in association with DataEnvironment, DAO Method. When the programe is executed the report is getting printed exactly the way i need.

But when I update the table from where the DataReport is made, the changes are not shown in the report even after I closed the Report and Reopen it. I need to exit from the programme and to restart the programme to make the changes in the report.

I have already tried Datareport.Refresh command, which provide no use.

Can anyone suggest me a solution for this or any alternate methods to make a DataReport from a Table..?

Regards
MP



Thanks and Regards,
Arun Mohan M P

hello boss,
        i am also have the same problem,have you answer of this problem? plz,sent me.

Okay.
But what is the datasource of datamember in the datareport? Are you using command object with DE Connection or Stored Procedure?
If SP, then it must fetch the proper data evertime you open the report and it has to execute that SP on each load of report open.
If Command Object the, try to use requery of the command object and refresh the datareport.

Looks like the data is cached in the report because just binding the SP or command will not do a trick, it must execute every time the data report is initialized so it can fetch the current data.

Hope this helps.


With Regards,
Raghavendra Mudugal