ssrs

keshar · ‎10-02-2017

1. Question: I have created a report based on SP on SSRS. It is set as weekly Monday morning auto run and email the report to every subscriber Monday Morning with report link. The report is fine. It populate the weekly report. But when subscriber click the report link it update the report which I don’t want. The report should update only once a week where users click the report 1000 time. I need help from the export please.

v-jiascu-msft · ‎10-03-2017

Hi @keshar,

1. What's connection mode of your report? Direct Query or Import? If it's Direct Query, the report will always be the latest.

2. Did you set the Scheduled refresh? Maybe you can set it as the picture showed. Then the report will be refreshed once a week.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.