title: Adding multiple SSRS reports into one report is very slow
body: <p>I inherited a report from a developer where he combined 5 reports into one SSRS report.  It looks like he just copied and pasted each tablix from the original reports one below the other.  This was done so that when the user exports to Excel they can have each report on a separate tab.  I've never done a multiple SSRS report like this before so I'm just now analyzing how this whole thing works.  A major problem I'm finding is that it runs extremely slow, about 10 minutes, seemingly because it has to run all 5 queries.  Each stored procedure is listed separately as a data set.  Does anyone know a better way to create multiple SSRS reports onto one page, or at least how to make this thing faster?</p>