Hello

I have a stored procedure that returns two resultsets that have a master and detail relationship. I would like to know if I can make a report that uses this data in order to display a hierarchical relationship.

Thanks a lot.

 It is my understanding that as of SQL 2005 you cannot report on both datasets from one proc.  You could share that data with another proc (using temp tables) and make a sub report from it and tie them together.