|Dynamic Sql query in birt [message #548764]
||Thu, 22 July 2010 22:20
Registered: July 2010
I have a scenario where I need to create sql query dynamically based on table columns. |
That is, I am passing in a 'report id' as parameter to query.....then query fetches all 'report parameters' for that report id and gets 'report details' for each of the report parameter. The problem is report details table should be picked dynamically based on the 'report level' column in the report param table.
if value for 'report level'= ABC in reportparam table, then details table is ABC_report_detals and so on.
is there any way i can do it with property binder?
Any help much appreciated!
Powered by FUDForum
. Page generated in 0.01912 seconds