<p>Hi, </p>
<p> </p>
<p>When creating sub-reports using list/table combo with dataset parameters, does the dataset bound to the table call the database only one time or every time a new parameter is obtained? </p>
<p> </p>
<p>For example:</p>
<p>Suppose that I have a list 'A' that contains the set of unique ids, let's say 1,2,3...N</p>
<p>In the detail of the list 'A', I have a table with the query: </p>
<pre class="_prettyXprint">
'select A, B from XYZ where id=?'</pre>
<p>in the table's parameters I have a parameter definition, let's say itemID | integer | ..</p>
<p>and the table's dataset parameter (itemID) is bound to the list's detail id</p>
<p> </p>
<p>Does this mean that:</p>
<p>- as the list element cycles through the ids (1,2,3...N), the datasource is going to be accessed N times by the dataset bound to a table? </p>
<p> </p>
<p>If this is so, then it is somewhat 'expensive' to access the database every time data is needed. </p>
<p> </p>
<p>Are there any ways to pull the entire dataset and create subreports by applying the dataset filter that would change at each list's detail iteration and be equal to the value of the current id in the list detail?</p>
<p> </p>
<p>Thanks!! </p>
