Have a stored procedure that massages alot of data. It returns two sets of records. I would like to use the first set for the details of the main report and the second set as a subreport for those main report details. I could separate it into 2 sprocs, but would rather not since there's a lot hits to the server, why run it twice? When I refresh the dataset it only sees the first set of results. Anyway to make this work as is or should I just separate it?