[news.eclipse.birt] Dynamic table name within SQL

[Joachim Wesenberg <Joachim@xxxxxxxxxxxx>]

As an absolut newbie in BIRT maybe somebody can help:

I would like to construct a SQL-statement (data set) construcing a table 
name from a fixed prefix concatinated by a variable which stems from 
interactive parameter input "table_ID".

SELECT data_in_column FROM "table_" . params["table_ID"] WHERE ....

The entered table_ID might be "XY", so the substitued table name within 
the SQL statement should be "table_XY" which will result in

SELECT data_in_column FROM table_XY WHERE ....

I am not a programmer and simply would like to use the UI of the RCP 
report designer. Your help is very much appreciated.

Best regards - Jo