Using Groovy to generate dynamic query

[rshankar]

Using ireport 1.2.6.

 

Assume i have created a parameter TABLE (has a default value and is promptable) and then

when i try to create a groovy text expression parameter, say DYANAMIC such as below, and compile the report with

 

"select f1, f2 from " + P{TABLE}

I get an error:

 

net.sf.jasperreports.engine.JRException: Too many groovy classes were generated. Please make sure that you don't use Groovy features such as closures that are not supported by this report compiler.

 

Is this possible or not?

 

thanks,

 

Shankar

[shiwakant]

If you see your expression below you will find that $ Sign is missing

"select f1, f2 from " +$P{TABLE}

 

I too got similar error below on this. Where P was missing :)

$P{SUBREPORT_DIR} + $P{ENT_SUB_REPORT}

[molay_dutta]

Hi Shankar,

 

Try this...

 

select f1,f2 from $P!{TAB_NAME}

 

Regards,

Molay