process jasper parameterized queries

[e_kannan]

how to pass parameters to our report

sql?

 

for eg., i have a file named

test.xml.

i have a query like

<report>

<sql> Select name,no,address from emp where

no = nvl(?,no)</sql>

</report>

 

is the above sql query is possible to give?

If yes, then how to send the value to that query?

 

Advance thanks to the reviewers.

 

thank you

kannan.

[csbac]

See

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=9&id=23275

and

http://www.jasperforge.org/images/stories/Documentation/ireports/swf/Parameters_viewlet_swf.htm

about using parameters.

 

Yours,

Sebastian