Variable Table Name getting Data Set

Hi all!

I´m trying to load a Data Set by by doing a select with a parameter as table name, but something is wrong. I´m trying something like that:

select * from ?

How can i do this in Birt?

Thanks a Lot!

Find more posts tagged with

Comments

bhanley

BIRT does not allow dynamic substitution of the table name in the query. You can only parametrize the WHERE portion of the query. 
 
In order to do what you want you will need to use some simple scripting on the data set. It should be pretty easy for you to get up and running. Check out this post: 
 
<a class='bbc_url' href='http://www.birt-exchange.com/forum/designing-birt-reports/13580-birt-scripted-query-question.html#post42438'>http://www.birt-exchange.com/forum/designing-birt-reports/13580-birt-scripted-query-question.html#post42438</a> 
 
Good Luck!

alfgom

I got it!

Thanks...you`re right is on this way. I´ve tested it before, but for some strange reason it doesn´t work. I have deleted the param and then I´ve created it again and now it works.

Thanks again.