use $P{param} as select * from $P{param}

[openxadmin]

Trying to use the params for the tablename.  If I can get this working it means I can use the same sub report for multiple tables by just sending the tablename to the sub report.

 

I have been using the parameters in joins and where clauses for a while and am supprised that the param will not work with the tablename.

 

Any Ideas other than writing the jrxml before compiling the sub report?

 

Chris

 

select CAST(date_format(from_unixtime(timestamp) , '%Y-%m-%d' ) as DATETIME) as date,
round(max_value,2) as max,
node_ref_table.node
FROM $P{table}
JOIN node_ref_table ON ( 
node_ref_table.ref = node_ref 
and node_ref_table.ref =  $P{node})

 
group by node limit 10