Have you tried the concept of drilldown in ssrs? Read this article I wrote on creating a drill down report .. http://sqlsaga.com/ssrs/how-to-create-a-drill-down-report-using-ssrs/[/url]
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.