The Selected JRXML could not be parsed

 
 
<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.
sabrish.jackson007_1's picture
Joined: Jul 26 2017 - 4:20am
Last seen: 4 years 9 months ago

0 Answers:

No answers yet
Feedback
randomness