Hi,
I'm new to the reporting service. I followed the tutorial from the online book and created the basic report. After I deployed the report and opened it in the browser, it kept reloading the page automatically. Seems to me the page is reloaded at least 5 times per second. I turned off the Autorefresh for the report. It still behaves the same. That causes the CPU of my computer runs on 100% constantly. Can anyone help me to solve the problem?
Thanks,
Jia
Jia,
One way to get a report to refresh is the 'Autorefresh' property (Report Properties, General Tab, Autorefresh checkbox). You've already verified that that checkbox is unchecked (this is a design time property).
A report can also be refreshed based on the Report Server's caching property. To change this setting, you can use the Report Manager. Make sure that you've got the following radio buttons selected and no others (available when you deploy to the report manager, run the report, select the Properties tab, and the Execution page):
Always run this report with the most recent data|||
Hi Tnx1m,
I did as what you said. Unfortunately they didn't work.
After the first page is loaded, the page starts to *flash*. I use SQL Profiler to check on the backend. There is no query sent to the database. It looks like the page is in an infinite loop to be refreshed but not sending any commands to the database. Any idea why it is like that?
Thanks,
Jia
|||Hi Hia,
seems like you are running IE 7 Beta 3 :-) Look here for more information about this: http://sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/EntryID/10/Default.aspx
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi Jen,
That's exactly where the problem comes from. Thanks so much!
Jia
No comments:
Post a Comment