Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim_cool
Starting Member
43 Posts |
 Posted - 2006-02-07 : 05:26:07
|
| hi alli am working in sql reporting 2000.In my report i have included field to display the execution time.That time is not changing if i am running the report again & again.Its only showing the time at which report was run first time in current Internet Explorer window.how can i get current time in report?plz help me. |
|
|
jhermiz
3564 Posts |
Posted - 2006-02-07 : 08:37:21
|
Delete the .rdl.data file in your report solution folder.Then rerun the report.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
jim_cool
Starting Member
43 Posts |
Posted - 2006-02-07 : 23:12:28
|
| Hi thanks for ur reply.But i still have some problem .Actually whaen we run report manager we get two refresh buttons one of IE window & one provided by report manager for refreshing reports.Now the problem is that if we click on refresh button provided by report manager then the execution time in report is updated but if we click on IE refresh button then it shows that report is being generated but the execution time is not updated.So what is the solution for this? |
|
|
|
jhermiz
3564 Posts |
Posted - 2006-02-08 : 07:30:04
|
I just told you, delete the .rdl.data file. If you refresh the report it works fine which is what is expected, IE refreshes your page not the report. The report is a container item and you need to refresh the report to make a trip back to the server to revalidate your data.Please do some research on your own, look into the settings of your report manager and their are many options to auto refresh, not cache data, etc etc.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
|
|
|
error in execution time