title: Exporting parent report's subreports into a single Excel sheet?
body: <p>I'm using SQL2008 R2.</p>
  
  <p>I have a parent report, with a sub-report. The user is prompted for a date and variable number of "areas". For each area selected, that area gets its own page which is the sub-report containing that area's data.</p>
  
  <p>When exporting, each area gets its own sheet.</p>
  
  <p>In SSRS, how can I force the dynamic number of sub-reports into a single Excel sheet on export? </p>
  
  <p>There could be hundreds of sheets generated and I can't expect the user to cut/paste the data into a single sheet every day.</p>
  
  <p>Specific example:
  I pick Pittsburgh West and Pittsburgh East, and export. Sheet 1 is Pittsburgh West data, Sheet 2 is Pittsburgh East data.</p>
  
  <p>I want to maintain the headers but have all of the selected area's data on Sheet 1.</p>