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

[Joachim Wesenberg <Joachim@xxxxxxxxxxxx>]

Wenjie Tu wrote:
> 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 
Wenjie,
thank you very much for your help. It worked.
Best regards - Jo