I have a master stored procedure called the conductor that does some general work with input parameters and then hands off a tighter parameter list to one of 6 stored procedures that will return a result set.
Using SSRS to display the results is a business mandate, but I do not believe that I'll be able to get results from a nested stored procedure as reporting services would not be able to define the column list a priori.
Has anyone dealt with such an issue, and if so, what path did you take?
Keith Wiggans