Using Temporary Tables and Re-Using Temporary Tables in a SSRS Report

Question

So we need to standardize Member Eligibility by using a SQL Server Stored Procedure that will be called, Executed by our Patient/Member SSRS Reports.

The SQL Server Stored Procedure currently uses a Global Temporary Table to pass its result set back to the calling Report's SQL Server Stored Procedure.

Just trying to think the best way to go about doing this as multiple reports may be running or kicked off at the same time to utilize this standardized executed SQL Stored Procedure.

Maybe a Staging Table is a better idea but we will need someway to discern my result set, Business User #1, from say Business User's #2 result set. Even if it is in a Staging Table, I guess we'd have to incorporate cleaning up that Staging Table upon the final report result set presentation SELECT.

Why we were thinking more of a Global ##Temporary Table because that would purge itself after execution. But then we have the dilemma of how we'd name that Global ##Temporary Table to make it unique from one report execution to the next and across reports.

Just wondering if anyone has faced this dilemma before and logistics of dealing with Temporary Tables and uniquely defining and using a Temporary Table across SSRS Reports so if re-using a standardized SQL Server Stored Procedure my result set is unique and different from say Business User #2.

Any insight and help would be GREATLY appreciated.

Thanks!