Report Designer: Refreshing Fields VERY Slow

I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parameters
which because of the size of the tables takes a long time.
I have tried changing the data type for the parameter from String to
DateTime and neither seem to refresh the fields quickly.
Can anything be done to refresh the fields list quicker?I thought my MSDN Universal Subscription entitled me to a response within two
days... I guess not.
"Chance" wrote:
> I have a query that uses temp tables, and the query seems to execute and
> refresh fields fine, but as soon as I put in a parameter for a DateTime field
> the query will run but the Refresh Fields button takes forever...like 2
> hours! I think it is running my rather lengthy query without the parameters
> which because of the size of the tables takes a long time.
> I have tried changing the data type for the parameter from String to
> DateTime and neither seem to refresh the fields quickly.
> Can anything be done to refresh the fields list quicker?
>

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

sql