<p>I have BIRT working to the extent of calling the engine from JAVA and writing reports out to PDF or displaying in the viewer. We have the requirement of needing to add a WHERE clause to the query dynamically from our application. This WHERE clause will vary dramatically each time it is run by table and column so I am thinking parameters are not going to work unless I can set one parameter and set it to the complete WHERE clause. Ideally we would like to change the query in any way we want while maintaining the output columns. </p>
<p> </p>
<p>I have been fighting how to pull out the dataset queries, modify them and run the report using this modified query. We need to do this all within JAVA with the API's. BIRT has been easy to this point but now I am lost. Can someone point me in the right direction?</p>
