JasperReport parameters works in iReport but fails

2019-02-23 18:00发布

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条回答
Emotional °昔
2楼-- · 2019-02-23 18:54

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

查看更多
登录 后发表回答