To run the 8 reports at once and export it all to one Excel file, create a main report with Subreports.
Here are some sites that show how to create subreports:
http://www.katieandemil.com/ssrs-create-subreport-with-parameter-example-tutorial-
ssrs-2008-r2
Create the main report
- add a table
- remove 2 right columns
- Create 8 detail rows - right click Details Row, Insert Row, Inside Group - Below
- Set page breaks (will create separate tabs when Exporting to Excel)
- Right click on a Detail row
- Choose Row Group, Group Properties
- go to Page Breaks, check Between each instance of a group
- Add a subreport to each Detail row of the table and configure it for each report
*if there are parameters on the subreports, you will have to add them to the Main Report and pass them to the appropriate subreports
In SSRS 2008 R2, you can configure each Excel tab name.
To set the tab name when exporting to Excel -
- click on the Row Group name in the box below (can be on a group you create or use Details group)
- In the Properties window, expand the Group section
- put the field in the PageName property - for example: =Fields!TerritoryName.Value or use text - type it in
See website: