Creating Dynamic Query in birt report

Hi All,

I have created a birt report design that fetch data from DB and display the records and its working fine.
Now my job is to form the sql select query based on the values selected on the jsp page.

For example:

I have displayed the records from the DB into the display tag in the jsp with date as one field. The user will select the date based on his need.

i need to get the date and generate the query and produce the report as pdf.

now my question : Is their a way so that i can pass the select date using the birt:param to birt report and form the query dynamically

I will give a sample query in which i need to form the condition using the report parameters

SELECT id,date,name
FROM table
WHERE QUARTER IN ('05-2012,?,?,?......')...
In the where condition my parameter values has to be placed and form the query.

Can any one let me know how to create the dynamic report parameters and form the dynamic query with the selected values from the jsp

thanks in advance

Find more posts tagged with

Comments

AlexAD

Hi. 
 
You can either use <blockquote class='ipsBlockquote' >this.queryText</blockquote> referring to your query in the beforOpen method on a data set, or try to bind a BIRT's parameter to your query (there are tutorials about that). 
 
P.S. Not a BIRT expert.