Switch to full style
Java2 codes,problems ,discussions and solutions are here
Post a reply

BIRT reporting

Thu Oct 23, 2008 12:36 am

Any body has experiance using BIRT report ?
I have one report parameter.
I just want to create if the user specify the report parameter, the sql will
execute sql with where clause (ex: select * from user where userid=?), but
if no report parameter specify, i want to execute the sql without where
clause. (Ex: select * from user)
Is this possible ?



Re: BIRT reporting

Thu Oct 23, 2008 12:37 am

specify query in the Data Set's beforeOpen method, like


this.queryText = "SELECT * FROM " + params["myParam"]

Post a reply