I'm not sure of the exact scenario you are describing, but you can use various types of User Filtering to display only applicable data for the logged in user
You can also now connect to Stored Procedures now in 8.1. Not sure if there's a way to accomplish what you want using a sproc.
If this isn't helpful, can you describe what you are trying to do in another way?
That's exactly what I was looking for. Thanks so much for your quick help.
No problem; be sure to mark the question as "answered" so other helpers know you've found a solution. Cheers!