One solution could be to have separat tables for each report with different row level security in each of them and then in each report you link one of the RLS tables to the data table,
I dont know if this will be enough for you but maybe worth a try 🙂 ?
//Fredrik
... View more