Set the report's AutoRefresh property with the number of seconds.Press 'F4' on the report for open properties window.
SQL Server Tips · · · ·
This will only work with reports rendered as HTML. It will not give the expected results when rendering to PDF, Word or Excel. Reports rendered in those formats will be static.