I'm developing some report with BIRT, each report have a Dataset with an SQL query inside, then from my Java application through Report Engine API (BIRT Runtime 3.7) i pass the JDBC connection object with a code like this : <br />
<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>task.getAppContext().put("OdaJDBCDriverPassInConnection", this.conn.getConnection());</pre>
<br />
<br />
The database connection that the java application pass to the report task could be linked to different database server (mainly MySQL, PostgreSQL and Sql Server ), since some query are quite complex some times i need to change some expression in the query based on the database server type linked by the connection because the syntax can vary from database server to database server ...<br />
<br />
Is there a way for change the entire query or a part of it based on the database server type linked to the connection ? <br />
<br />
How can i do it ?<br />
Can i modify the query directly in the report event with JavaScript ? <br />
<br />
<br />
Thanks.
