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

["Wenjie Tu" <night.roger@xxxxxxxxx>]

in "Edit Data Set" dialog,  choose "Property Binding", then in "Query" 
textbox, input:

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

Wenjie
Thanks

"Joachim Wesenberg" <Joachim@xxxxxxxxxxxx> wrote in message 
news:gei1je$jm0$1@xxxxxxxxxxxxxxxxxxxx
> 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