Forum Discussion

keshar's avatar
keshar
New Member
8 years ago

ssrs

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.

 

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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