Hello,
I need to select a some table in query. The name of that table is given in
java class that passes it to my .jrxml file to be used in my querystring.
I set parameters in javacode like this:
Map<String, String> inputParameters = new HashMap<String, String>();
...
inputParameters.put(jrxmlFieldName1,jrxmlParameter1);
inputParameters.put(jrxmlFieldName2,jrxmlParameter2);
jasperReport =
JasperCompileManager.compileReport(getJRXMLName());
jasperPrint = JasperFillManager.fillReport(jasperReport,
inputParameters, connection);
I and I am trying to run the following query:
<parameter name="selFileVersion" class="java.lang.String"
isForPrompting="true" >
<defaultValueExpression
><![CDATA["someFileVersion"]]></defaultValueExpression>
</parameter>
<parameter name="selId" class="java.lang.String" isForPrompting="true" >
<defaultValueExpression
><![CDATA["Id"]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select * from $P{selFileVersion} where Id = $P{selId}
]]>
</queryString>
<field name="Id" class="java.lang.String"/>
That querystring doesnt work. What is wrong?
Thank you in advance for soon reply!
--
View this message in context:
http://www.nabble.com/queries-question-tp18608006p18608006.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
