Auto Refresh Option In SSRS

Report Services Auto Refresh Option ( method 1)

 “How do I get my report to automatically refresh so the end user of the report doesn’t have to constantly click the refresh button?” 

The two different methods to achieve the same result. The first is by going to the report property and clicking anywhere in the space around the Design area(You should not click in the body area or any of chart property ).

Now you click on the Properties Tab or click F4 to get to your properties. When you see your properties options, look under the category “Other”. You should see the AutoRefresh option.

AutoRefresh is calculated in seconds and the student needed it set to refresh every 5 minutes. So we changed the autorefresh option for 300 seconds.

Report Services Auto Refresh Option ( method 2)

The second option to set your autorefresh is by right clicking on the report itself located under the Report Folder in your Solution, and selecting “View Code”.

Once in the code, don’t be alarmed by the amount of content that you see.  Search  AutoRefresh option in the code. you will see codein as follows.

Once you have found your AutoRefresh, you can set the time by deleting the Zero and replacing it with the number of seconds you need it to be. Click the save button and you are done.

thats all :-)