Jeff Moden (10/29/2013)
OPTION 3:Do it all in T-SQL (control SP that calls the other 2?) and just present the final result set to Reporting Services.
Agreed, Jeff. If the assumptions are correct and the user can have a controlling SP then option 2 can be done on the server side only allowing for greater control.
Fitz