SSRS Auto refresh Dataset

Antony Durai 0 Reputation points
2023-07-29T11:46:11.1666667+00:00

Hi,

I am having a SSRS Report which is scheduled to auto refresh every 15 Minutes.

Its works as expected till now but my question here can I schedule this auto refresh schedule only particular time during a day.

for example I want this auto refresh to work for the report only 7AM to 12PM.

How should I implement the same in SSRS?

Regards,

Antony

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,065 questions
Windows for business | Windows Server | User experience | Other
SQL Server | Other
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2023-07-31T02:25:26.9166667+00:00

    Hi @Antony Durai

    How about using a function in the AutoRefresh property? When the time is from 7AM to 12PM, the refresh interval is 15 minutes, otherwise it is 0.

    For example:

    Screenshot 2023-07-31 102345

    Best regards,

    Aniya


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.