Fetch only new or updated data from Last run
I am very new to Reporting hence need help to devlop report to fetch only incremental data.
1) Report will be called by Webservice by passing parameters.
2) Report will fetch data from tabel inv_material_txns and pass Work Order number to wie_work_orders_b to fetch Work order & Work order type.
I have created basic SQL to fetch data. But I am not able to figure out how to fetch only incremental data from last RUN. i.e report should fetch only data that is new;y created or updated since last run of this report.