SSRS: AutoRefresh Property

Report Services Auto Refresh Option

In one of my Virtual Training classes that I taught, I had a student ask a question that I felt was a great question and would be good to share the answer with the community.  The question was, “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?”  That is a great question, because I am sure that people commonly have to set their reports up in that fashion.

I will show you 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.

From here, 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.

So that is one method for AutoRefresh.  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. 

Here is the easy way to find your AutoRefresh option, you hold down your CTRL F to do a FIND.  Type in AutoRefresh and hit Find Next:

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.

I hope you have enjoyed your quick tip.  Have a safe and wonderful weekend.