Still a problem with Report Refresh Icon

In my installation of RS 2005 when I click the Refresh Icon on a report the report doesnt update. But when I click the "View Report" button it does.

For example, if I change the parameters on the report and click the refresh icon the report seems to flicker as if it was rfreshing but the report data remains the same, even the paramaters in the report remain the same (I have the parameters that are selected in the report header)

Anyone have the same problem or know the solution

Answer this question

Still a problem with Report Refresh Icon

hoang khoa

Reports are cached within Reporting Services, clicking refresh just reloads it from the cache. Only by clicking on 'View Report' does it actually re-execute the report. This behaviour is by design and is documented in the help files. It is also discussed in the official training course (Course 2030).

Regards

Paul
Anand Ramasubbu
Hi,

No, the report is not being executed from a snapshot\cache. So at least I know that the behaviour I have found is not something specific to my RS 2005 installation.

Does anyone know if this is a bug as it used to work in RS 2000.

Thanks

N
George Ionita
Yes, SP 1 is installed.

Are you suggesting that the Refresh Icon "should" refresh the report and pick up on newly selected paramteres in the report
Elaine brockway

Is this within Visual Studio or Report Manager

Regards

Paul
Mike_Lange
The refresh button will cause the queries in your report to reexecute. So with the refresh button, you will see the most recent data. But it won't use new values entered in the parameters area. Those are only submitted when you click view report.
helper
No one knows
yus_nash
In Report Manager.

Thanks

N
Tiki_at_YB

Not really. Just wanted to try to reproduce it on my system.

I does not pick up the parameters, just refreshes the page. Looking at the HTML source shows that it is definately doing a postback. Any Changes to the parameters are retained, therefore are stored in ViewState. But it is not re-executing the query/report.

I'll have to try it out on RS 2000 as I can't quite remember what behaviour occured.

It could be a bug

Cheers

Paul
Edgar Esquiaqui
In addition to what Brian has already said, the "refresh" button is subject to the execution options of the particular report. If the report is executing from either an execution snapshot, history snapshot, or cached (time-based) snapshot, then the "refresh" button will not resubmit the queries. This is by design.
indiana_jones81
Thanks for the reply. This behaviour is different in RS 2005 so It used to fully refresh the report in 2000 when clicking on the Refresh icon.

Whats the point of the Refresh Icon if it doesnt actually refresh the report after you change the report parameters
mrKelly

Correct. And 'yes' I have been able to reproduce it on SQL 2005.

Cheers

Paul.
Filip Orsag
Have you applied Server Pack 1 for SQL 2005
_dot_
Ok thanks.

Why did this change in RS 2005 It has caused some users a problem as they expected the report to pick up the new parameters like RS 2000 did. Just wondering why this functionality changed....

Thanks

N
Captain119
Thanks Paul.

It used to work in RS 2000, so maybe you are right, it could be a bug. It would seem strange to remove good functionality in RS 2005. Its not very intuitive that the report does not pick up on new parameters when you hit the Refresh icon.

Let me know if you can reproduce this behaviour...

N
Still a problem with Report Refresh Icon

Answer this question