|dynamic data set from different table different feilds, according to parameter [message #684219]
||Wed, 15 June 2011 04:49
Registered: June 2011
I just start BIRT so might get some wrong way. And this might sounnds a common question here.
I would like to fetch different feilds from different table according to one parameter's value.
Say if parameter value is "Apple", I would do query:
select taste from table_fruit;
if parameter value is "Rice", I would do query:
select protein from table_grain;
I knew I can do something in data set "beforeOpen" to replace string. But how can I control both the table name and the field name with one parameter? I am sure there are plenty of solution for this thing.
Powered by FUDForum
. Page generated in 0.08654 seconds