<subreportParameter name="start_date">
<subreportParameterExpression><![CDATA[$P{start_date}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="end_date">
<subreportParameterExpression><![CDATA[$P{end_date}]]></subreportParameterExpression>
</subreportParameter>
But I dont want to pass any input parameters, instead the below altered query should pass the value by executing the query. So, I tried to change the above code into
<subreportParameter name="start_date">
<subreportParameterExpression>
<queryString><![CDATA[select to_char(trunc(trunc(sysdate, 'MM') - 1, 'MM'),'YYYYMMDD') from dual]]></queryString>
</subreportParameterExpression>
</subreportParameter>
<subreportParameter name="end_date">
<subreportParameterExpression>
<queryString><![CDATA[select to_char(trunc(sysdate, 'MM') - 1,'YYYYMMDD') from dual]]></queryString>
</subreportParameterExpression>
</subreportParameter>
And after changing the same if I try to upload that file into JasperServer Reports, It gives me the below error.
Could anyone please advise what could be possibly wrong.
0 Answers:
No answers yet
