Report not taking into account data over line 1000

[TomD]

Hello

I have a large Google sheets form with about 2000 lines and growing.
I have set up a report to notify me for inventory items that expire within the next 60 days that runs each week.
The report works fine for all the items in the first (aprox) 1000 lines but after it seems that the data is not taken into account anymore.

If I place the line higher up in the sheet then the report works fine so the data in the line and expression seems to be ok.
My expression is AND([Expiry Date]<Today()+60,[Station]=“XXX”)

Any ideas?

[Steve]

It would seem there’s something problematic about the data after the first 1000 lines. What’s different?

[TomD]

There doesn’t appear to be anything different, all the lines are read in appsheet, just the report doesn’t take the data into account. If I copy/paste the line lower in the sheet to the beginning, it works fine.

[Steve]

Is every row’s key column different from every other?

[TomD]

Ok found what it was, security filters were causing a problem.
The odd thing was that in UX the slice info was displayed correct but in the behavior/report the info was not included.
Selecting “bypass security filters” solved it.
Thanks

[Marc_Dillon]

1000 records is the limit for tests. Are these reports actually running, or are you just testing them?

[TomD]

I am actually running the report, I found the test is indeed limited.