<p>I am getting an error on my parameter when trying to run this query in Birt. It is coming from the <strong>revision_id</strong> parameter. The query runs fine in the SQL management studio but gives me this error when trying to run it in Birt:</p>
<p><em>org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</em></p>
<p> </p>
<p>Am I unable to put a parameter there?</p>
<p> </p>
<p>select<br>
subproject.project_id<br>
,subproject.subproject_id<br>
,subproject.project_name<br>
,subproject.project_type<br>
,(select sum(amount) from subproject_budget where (subproject_budget.project_id = subproject.project_id<br>
and subproject_budget.subproject_id = subproject.subproject_id) and <strong>subproject_budget.revision_id = ?</strong>) as budget<br>
from subproject<br>
where subproject.project_id = ?</p>
