SSRS sub-reporting and multiple datasets

Question

I have a main one page SSRS report which links to 16 individual tabs (when exported to excel).

Tabs 1-8 all use the same dataset, and as they are built individually, when the main dashboard runs, it takes an awful long time running the same dataset 8 times on each subreport... Is there anyway to make the main dashboard run whilst querying it only once? Tables 9-16 use different unique datasets.

Answer 1

I suggest you use shared dataset for 1 to 8. By using a shared dataset you can provide a query that can be used by more than one report.

You can read more about shared dataset here. https://msdn.microsoft.com/en-us/library/ee633675.aspx