SQL statement into parameter???

[2004 IR Help]

By: jlsoft - jlsoftspain

SQL statement into parameter???

2005-09-14 05:31

Hi!!

 

I?m newbie in Jasper Reports and I have a question for you:

can i send SQL statement as parameter to jrxml and then, into jrxml add next code:

 

<queryString>

<![CDATA[ $P{QUERYPARAMETER} ]]>

</queryString>

 

??

I try it but and error occured.

 

Thanks in advanced

 

 

 

 

By: macoute3 - macoute3

RE: SQL statement into parameter???

2005-09-14 05:44

$P is just for a simple parameter.

For complex expression, use $P!{QUERYPARAMETER}

 

 

 

 

By: jlsoft - jlsoftspain

RE: SQL statement into parameter???

2005-09-15 01:29

Thanks very much, macoute3!

 

I will write more in this forum, it?s great!