Pass data from ssrs subreport to parent

Question

1 Is it possible to pass data from ssrs 2005 subreport to its parent report? 2 If yes, how? Thanks so much Philip

Answer 1

Its has been posted on another forum that this cannot be done :(

Answer 2

You might be able to add a subquery to the query in the main report to get totals:

SELECT
   t1.ClientID,
   t1.Address,
      -- Subquery to get invoice totals:
      (SELECT SUM(InvoiceTotal)
      FROM Invoices
      WHERE Invoices.ClientID = t1.ClientID)
   AS InvoiceTotal,
   t1.CompanyName
FROM Clients t1;