The Selected JRXML could not be parsed

[sabrish.jackson007_1]

HI Team,

 

I have a .jrxml file where they expect the input parameters. Below is the code.

 

<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. 

 

Upload a Local File

The selected JRXML could not be parsed. You might have selected the wrong file.

 

Could anyone please advise what could be possibly wrong.