SQL Reporting Services Stored Procedure

Using Reporting Services, how can I use a parameter to return 2 variables for a stored procedure. What I am trying to do is get values for two variables (manager and worker). I need to set up the parameter so when a worker is chosen as @worker then his/her manager is also automatically chosen as @manager. Its almost like I need to have a hidden action that will select the manager in the background. This is somewhat confusing so if clarification is needed please let me know. Thanks.