Refreshing Report Data in ReportViewer

Hi All,
I am using reportviewer component to present data,
On Clicking report button report is generated with data , now if one makes
some changes into database. and on cliking the view report button again
(second time or n times), it actually does not go to database and get the
latest update, Same old data is displayed with out updating with new records.
How to get the latest data from database on click of Report button when
there is change in the data in database
To over the above problem i followed two steps as follows.
1. In the Report Manager -> Property tab -> Execution Linke
the option "Render this report with the most recent data" is selected.
But this doen't work.
2. I don't want to check the AutoFresh Property of Report in VS.NET ( Reprot
Designer).
I am sure this is common problem which all might have faced .
It's very urgent, Pls Help
Thanks is Advance.
Regards,
Ajay Kumar
Thanks,
Jim.If you are doing this manually you can click the refresh button in the
report viewer. I have found that the "view report" button doesn't
refresh the report...it generally works off of a cached copy even if
you aren't caching. There is a small button just to the right of the
export area that will refresh the report.|||Yes, i know that there is refresh button but i need automatically. Any how
i have solved this by adding a line in reportviewer control.
Thanks
Ajay
"Luke" wrote:
> If you are doing this manually you can click the refresh button in the
> report viewer. I have found that the "view report" button doesn't
> refresh the report...it generally works off of a cached copy even if
> you aren't caching. There is a small button just to the right of the
> export area that will refresh the report.
>