do you have complete list of those users? You can add user list as a separate datasource and then created Parameter which will source from it. Then add this parameter to the custom SQL of the big datasource.
What database is that? Can you create there stored functions/procedures?
Thanks. i actually figured it out after some search but thanks for reply.