Instead of two data pages to accomplish a dynamic filtered search on one page, just include the fields that can be filtered on the report just like the sort option. Even if it is a single filter field and filter value it would be better than nothing or having to using two data pages. If it could be completely dynamic like the designer datasheet view of tables in Caspio, that would be AWESOME!
Agree with this! Sometimes we don't know what an user may be interested to see from the data table, so having an interactive sorting option would be good.