Hi, Brian

Sorry for the delay

-

I am not sure if i fully understood your question,

but i can give you general information about using a source data table and filtering with Report Builder,  to start with.

As pointed out on this Documentation,

this depends if you use "Follow table filtering" –

 this checkbox is visible only if you did choose a wpDataTable data source on previous step.

 If this is checked, the report will always contain only the rows that are currently visible in the wpDataTable when it’s placed on the same page, in the same order. 

So if a table is sorted, filtered, etc., the rows will be used in the report same as they appear on the page.

 If this checkbox is unchecked, or if the wpDataTable isn’t present on the same page with Report controls, whole table will be used in report every time. 

Important to note : if the table has more rows that are currently visible, the invisible ones won’t be used in the report if the follow table filtering is enabled – to use them you would need to select “All” in wpDataTables “Show … rows” dropdown on the front-end.

-

Let me know if that answers the question, but if you perhaps meant something else,

could you elaborate a bit more and we will advise? Thank you