nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to customizes query for parameter

404040

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

Find more posts tagged with

Comments

404040

<p>kindly reply for this post.....</p>

kclark

<p>Take a look at my example, I didn't include quarters in it, depending if that information is in your DB it wouldn't be too hard to add. I created three datasets for customernumber, month, and year. Then created a cascading parameter group. Then I created a data set that would pull only the data selected from the parameters. Let me know if you have any questions!</p>

404040

<p>Thank for reply sir i have attached a report which i have created in sample db for my requirement but its </p><p>showing some error and i dono how to pass parameter by script in before open so can u able to pass parameter </p><p> </p><p>i.e i can't able to pass parameter for year,quarter,month </p><p> </p><p>so can u able to pass parameter in this report ..its urgent needed...</p><p> </p><p>thank u in advance</p>

404040

<p>kindly reply for this post.....and for link which i given below</p><p><a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php?/topic/29778-how-to-crab-series-value/'>http://www.birt-exchange.org/forum/index.php?/topic/29778-how-to-crab-series-value/</a></p><p>thank u in advance</p>