Cascading parameter for Date

puraghav

<p>Hi experts,</p><p>I am new to this actuate birt . I am trying to generate a report with cascading parameters. in parameters i have date selection.The cascading list box should have the drop down of data between the two dates but here i am getting full data of which existing in dataset. i need only between the two dates.i Attached screen shoot of my report parameter. Can any one help me on this </p><p> </p><p>Advance thanks</p><p>P K</p>

kclark

<p>You'll need to create two data set's to do this.  The first one is to get the dates for your to and from parameters.  The query using the sample db would look something like this</p><pre class="_prettyXprint">select paymentdatefrom payments</pre><p>Then your second data set will get the rows depending on your cascading parameter values.</p><pre class="_prettyXprint">select checknumber, paymentdatefrom paymentswhere paymentdate > ? and paymentdate < ?</pre><p>Then you create a new cascading parameter group and create two parameter for your to and from dates linked to the first data set.  Then create a third parameter linked to the checknumber in the second data set.</p><p> </p><p>After you've done this you need to go back into the second data set ui > parameters > and link each to and from parameter to the to and from parameter in your cascading parameter group.</p><p> </p><p>Now you should be able to select to and from dates and the checknumbers that appear with fall between the two dates.</p><p> </p>