Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display Last Dataset Refresh On Report

I have users that want to see the Last DATASET refresh time on their reports.  So if the dataset refreshed at 1:00 and they view the report at 2:30, 1:00 should be displayed.  This is very useful in ...
dataset refresh
  • cbarrettEM's avatar
    cbarrettEM
    6 years ago

    For a SQL data refresh it will be stored in the logs

    ReportAction 19 is Data Refresh, so something like:

    select max(timeend) as LastRefresh from ExecutionLogStorage where reportaction = 19 and ReportID = YourReportID

sharathkmv's avatar
sharathkmv
New Member
6 years ago

Create a column in some table in your dataset:

 

Refreshed = NOW()


NOW() is not the time of the Last Refresh. The time of the last dataset refresh might have been hours ago.

  • ktkpatra's avatar
    ktkpatra
    Frequent Visitor
    3 years ago

    Hello,

     

    I want to show dataset refresh date and time in report page not page refreshd date and time.

    Could you please let me know what need to do last dataset refresh page