title: Multiple reports generation in SSRS
body: <p>I have a fairly long report with about 20 pages, mainly charts (about 40) all using a subsample of the same dataset. This "master" report is iterated about 200 times by passing a parameter with such 200 different values.</p>
  
  <p>I was wondering whether there is a best practice for such case in terms of number of rdl files and datasets. Here are the options:</p>
  
  <ol>
  <li>1 RDL file &amp; 1 Shared dataset</li>
  <li>Multiple RDL files &amp; 1 shared dataset: the multiple RDL files are then included in a master RDL file as subreports</li>
  <li>1 RDL file &amp; Multiple Embedded datasets: each chart would have its own dataset</li>
  <li>Multiple RDL files &amp; Multiple Embedded datasets: the multiple RDL files are then included in a master RDL file as subreports, each chart would have its own dataset</li>
  </ol>
  
  <p>I see an advantage in option 1 as the shared dataset can be cached on the server making report generation much faster after the first iteration but I'm open to other approaches which might have other advantages.</p>