In the Action box, select "Jump to Report" instead and then pick which report to jump to.  I don't think you have to specify parameters when you do this.  You...

Do you have page breaks set up in your group?  If you do, remove them and your report should export to just one sheet in Excel.

Go the the properties of your textbox and click the three dotted box next to Action.  Select "Jump to URL" and then type in the URL you want them to jump...

David,

I think all you need are page breaks in your report.  If you set up a group (right mouse click on the Detail row header and Insert Group), select what...

Yeah, in the subreport properties window, click the Parameters tab and enter all the parameters you want to pass from the first report to the subreport.  If you set up...

If you are only passing one parameter in the URL and you don't have defaults set for the others, it will wait until you select something before it runs.  Either...

I don't know how to have a stored proc run a RS report.  If it's possible, maybe someone else knows how. 

Can you create subreports that are tied into your first...

Yes you can.  When creating your dataset for your report, make sure you switch the Command Type from "Text" to "Stored Procedure".  Then, instead of writing a query, call your...