title: How to use the same datasource twice in JasperReports/iReport
body: <p>I'm trying to work out how best to do reports with a chart then a table representing the same dataset. I  need to overcome the positioning of the summary is at the bottom, so intend to use subreports and table-subreports. I am experimenting with two tables and a chart in one detail band.</p>
  
  <p>If I set the <code>datasourceexpression</code> for to <code>$P{REPORT_DATA_SOURCE}</code> only the chart displays data (presumably the first subreport type item) and the tables are empty. Seems the data can be consumed only once?</p>
  
  <p>If I use a <strong>Dataset</strong> to query the database it works however it executes the Query three times, once for each table/chart. That will be a massive overhead.</p>
  
  <p>Obviously I am not doing this right but I cannot find any examples of using the same dataset more than once.</p>