If you don't have enterprise edition...I've acheived this using SSIS. Loop through a table of parameters and output reports (using a script task). Then used another loop and table of...

Forgive me if I'm not understanding your issue correctly, I'm new to this lark! I acheived something similar recently I think:

I passed a series of values generated via a SQL...

I hope I've understood this right...I'm don't use SSRS much...

Could you create the second table as a subreport and add that to the first table then filter the this based...

I've had the same problem - this was a really clean way to acheive what I needed:

http://sqlblogcasts.com/blogs/simons/archive/2009/06/23/Exporting-XML-data-from-SSIS---nugget.aspx

Instead of exporting directly to excel which doesn't contain the subreport data I export to CSV. I then have a workbook saved that uses the csv data as a datasource...

Only just starting out on the sql server BI road but I've acheived this by exporting to CSV and then linking to this from an excel workbook.