JasperReport parameters works in iReport but fails

2019-02-23 18:47发布

问题:

I have a report created in iReport. Have a parameter set with isForPrompting="true". When I go and test it with preview, everything works.

Parameter: Symbol
SQL Query: select * from "table" where "column" = $P{Symbol}  -- I'm using Postgres.

Then I use Repository Navigator to upload it to the server. The server returns "no pages" Any thoughts. I've verified that the report work in both iReport and JasperServer if parameter is removed and the value is hard coded into to the sql query like below.

<queryString>
    <![CDATA[select * from "tablename" where "column" = 'testsymbol']]>
</queryString>

回答1:

Yes, it was the input control. It's working now... thanks @precose!!!