<p>I have been tasked with fixing a previously working BIRT report that depends on one scripted dataset.</p>
<p> </p>
<p>Inside the fetch script there are approximately 5 other sql queries that collectively are not returning any records upon the results preview. For clarification, this is not a case of subreports linking to the main query; everything is placed inside one table within the layout.</p>
<p> </p>
<p>I've tried splitting each of the queries inside of the fetch script within their own dataSets, but haven't had any luck either (I'd prefer to maintain the state of the report structurely as close as possible to what it is now).</p>
<p> </p>
<p>Is there any linking that I could try within the same fetch script between the queries? I understand subreports use foreign keys from the main query and row calls within the child query, but again this isn't the case of a subreport.</p>
<p> </p>
<p>Thanks for your time in advance,</p>
<p> </p>
<p>Ty</p>
<p> </p>
<p> </p>
