Dynamic Table Name in report query

[jamescho99]

Using PRD 3.6, is it possible to create a query with a dynamic table name?

For e.g. select * from ${table_name} . Where "table_name" would be a report parameter. Report parameter substitution seems to work everywhere in the query except when using it in the "FROM" clause. Can someone verify?

[pmalves]

16:50 < Kaapa> andresF: no can do
16:50 < Kaapa> unless you pass the entire query, params have to be stuff you can use in prepared statements
16:50 < Kaapa> not the table
16:50 < Kaapa> you could use a kettle trans for it

[Taqua]

Bah! Use the "Advanced SQL datasource" and the following expression on the report's query attribute

="SELECT * FROM " & [table_name]

That will allow you to parametrize the query even on places where prepared parameters would not be allowed.

Also see Michael Tarallos Guide to Guided Adhoc Reporting for a live demo of that technique.
http://www.sherito.org/2010/11/demos...n-pentaho.html

[dmoran]

Thomas,

Did you mean "Advanced/JDBC (Custom)" ?

[Taqua]

Yes. That one.

[har123]

How do i do that for a parameter...?

[Taqua]

Before PRD-3.9: You dont.

After: Use the integrated scripting that comes with all major datasources.