|
Re: Birt 2.2.1 Fail to pass parameter with multi-values in drill-through link [message #514758 is a reply to message #514648] |
Tue, 16 February 2010 14:54 |
|
Are you using the IN filter on the dataset filter tab?
Also not sure if this will work in 2.2.1 but you can also do this in
script like the following beforeOpen script on the dataset:
var parmcount = params["parmorders"].value.length
var whereclause = "";
if( parmcount > 0 ){
whereclause = " where customernumber in ( ";
}
for( i=0; i < parmcount; i++ ){
if( i == 0 ){
whereclause = whereclause + params["parmorders"].value[i];
}else{
whereclause = whereclause + " , " + params["parmorders"].value[i];
}
}
if( parmcount > 0 ){
this.queryText = this.queryText + whereclause + " ) ";
}
Jason
shivbmsit@yahoo.co.in wrote:
> Steps
> 1. Create master report with static List Box as parameter with Allow
> Multiple Values Checked. 2. Create Hyper link and link to ListBox
> parameter of Detail report.
> 3. Sql query in detail report like select * from dummy. And filter in
> detail report as IN clause with detail report parameter.
> 4. When I click on hyper link detail report do not show any results.
> Kindly reply if any patch is available for Birt 2.2.1
> version. Thanks in advance.
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03070 seconds