Eclipse Community Forums: BIRT » how to customizes query for parameter

Home » Archived » BIRT » how to customizes query for parameter

how to customizes query for parameter [message #1069233]

Mon, 15 July 2013 09:21

Eclipse User

Hi,i have report with country,Fiscal-year,quarter,month in list box
if i have select Fiscal-year and then it have to cascade some value to Quarter and last parameter is month
for example:if i select Fiscal-year 2003-2004 and then it have to cascade for some value to quarter 2003 q1,2003 q2,2003 q3,2003 q4,2004 q1,2004 q2,2004 q3,2004 q4,
i have framed the query but its getting error so how to frame query for this and how to pass parameter?
i have attached a sample db for reference
kindly provide a sample db for this...

thank u in advance