Table name in QueryString and Parameters

[2006 IR Open Discussion]

By: Sam - ssa00319

Table name in QueryString and Parameters

2003-04-25 09:01

Hi,

 

It is possible to use parameter field to replace a table name in the Sql String by the value of this parameter (ex: "select * from $P{PivotTable}" or "select * from ?PivotTable" ) ?

If yes, how and which synthax has to be used ?

 

Thanks

 

 

 

 

By: Teodor Danciu - teodord

RE: Table name in QueryString and Parameters

2003-04-29 13:41

 

Hi,

 

You use the P!{param_name} syntax.

 

Check this:

 

http://jasperreports.sourceforge.net/tutorial/index.html#parameters

 

I hope this helps.

Teodor