I am trying to use BIRT as a java reporting solution. I am discovering that 2.2 will not allow me to use a report param as a schema name.<br />
<br />
The the SO post <a class='bbc_url' href='
http://stackoverflow.com/questions/603582/birt-2-2-dynamic-schema-name'>BIRT 2.2 dynamic schema name - Stack Overflow</a><br />
<br />
I have seen many examples of queries being built in the beforeOpen js however there really is no way to change the schema name on a table. <br />
<br />
for example:<br />
<br />
this.queryText = "select blah from schema.table where blah = 'blahblah'";<br />
<br />
becoming <br />
<br />
this.queryText = "select blah from "+params["SCHEMA"]+".table where blah = 'blahblah'";<br />
<br />
BIRT's inablity to handle this does not make any sense. How should this be done? Is there not some other solution that will work with 2.2?
