Skip to Content
-1
Jun 09, 2020 at 08:13 AM

BO Report to populate incremental data

123 Views Last edit Jun 09, 2020 at 08:19 AM 3 rev

I have a table SALES:

SALE_ID, SALE_TIME

S1, 6/1/2020 8:00:00 AM

S2, 6/1/2020 9:00:00 AM

S3, 6/1/2020 11:30:00 AM

S4, 6/1/2020 01:30:00 PM

And I have a report, which runs every day to pull all the sales details since last report run time.

For E.g. Day 1 report ran on 6/1/2020 at 10 AM And Populated the Claims S1 and S2 (Since S3 and S4 loaded after 10 AM)

And when the Day 2 report run, it should populate only S3 and S4.

I dont think LastExecutionDate() will work. Since I cannot pass the value in query.

Is there any way I can create this kind of report ( Report only incremental data)