I have a report created in iReport. Set the parameter with the parameter isForPrompting = "true". When I go and check it with a preview, everything works.
Parameter: Symbol SQL Query: select * from "table" where "column" = $P{Symbol}
Then I use Navigator Navigator to upload to the server. The server returns "no pages". Any thoughts. I checked that the report works both in iReport and JasperServer if the parameter is deleted and the value is hardcoded in the sql query, as shown below.
<queryString> <![CDATA[select * from "tablename" where "column" = 'testsymbol']]> </queryString>
source share