SQL Server Performance

A master-detail report from two resultsets

Discussion in 'SQL Server 2005 Reporting Services' started by EMoscosoCam, Jul 17, 2008.

  1. EMoscosoCam Member

    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.
    EMoscosoCam, Jul 17, 2008
    #2

  2. MichaelB Member

    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.
    MichaelB, Aug 4, 2008
    #3

Share This Page