Joined: Sun Oct 19, 2008 3:47 pm Posts: 281 Has thanked: 0 time Have thanks: 1 time
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 ?
AnswerBot
Question subject: Re: BIRT reporting
Posted: Thu Oct 23, 2008 12:37 am
Joined: Sun Oct 19, 2008 3:53 pm Posts: 229 Has thanked: 0 time Have thanks: 0 time
specify query in the Data Set's beforeOpen method, like
this.queryText = "SELECT * FROM " + params["myParam"]