SSRS showing old data in Report Server

• fritzjoery

  SSC Veteran

  Points: 273

  More actions

  October 4, 2018 at 4:27 am

  #364304

  We have 1 report that's being exported to PDF manually in the web page.

  However, when we update a certain value, the new value can be seen in the table but when we tried exporting the data, it keep showing the old value in the report.

  The stored procedure used in the report is showing the new value.

  It works fine when running the VS 2013.

  I am not sure if caching is enabled in our report server but in that RDL file, we did not explicitly specify to cached the data as shown below.

  Processing Option Screenshot
  

  Snapshot Option Screnshot
  

  Parameter Settings Screenshot
  

  There are no RDL.Data files in the report server as well and other reports are extracted to PDF and its working fine.

  Do you have any idea or did I missed something that needs to be checked?

  Thank you.