Setting a limit in selecting the report parameter

Hi all,
i want to set a limit to number of values selected at report parameter.could anyone suggest me any idea....

thanks in advance
Sankari

Find more posts tagged with

Comments

birtq

Hi,

do u mean restricting the number of multiple parameter value selected for a parameter?

Regards,
birtq

Sankari

Hi
S....u r correct...could u help me

birtq

Hi

Have a look at the Attached Report.I believe this is what you want.

Regards,
birtq

Sankari

Hi birtq

I cant open dat attachment...3.2.16 version is not supported here...so could u send me the steps

Thanks
sankari

birtq

Hi 
 
sure. 
 
In beforeopen of the datast where you want to put the where clause in sql statement. add this(modify it as per ur need) 
 
columnNameArray = params["parmorders"].value; 
 
var parmcount =columnNameArray .length 
 
var maxlimit=params["set limit"].value; 
 
if (parmcount>maxlimit) 
{ 
parmcount=maxlimit; 
} 
 
var whereclause = ""; 
if( parmcount > 0 ){ 
whereclause = " where customernumber in ( "; 
} 
for( i=0; i < parmcount; i++ ){ 
if( i == 0 ){ 
whereclause = whereclause + columnNameArray ; 
}else{ 
whereclause = whereclause + " , " + columnNameArray ; 
} 
} 
if( parmcount > 0 ){ 
this.queryText = this.queryText + whereclause + " ) "; 
} 
 
 
//** 
 
where params["parmorders"].value isthe multiple parameter value selection list. 
 
params["set limit"].value is the parameter as textbox with some default value(say 10),which is used to set the restricted number of parameter values from the list. 
 
Thats it!! 
 
Let me know if some other clarification is needed. 
 
Regards, 
birtq

Sankari

Hi birtq,

Thanks for the timely help....n it is working fine now....Thanks a lot

Sankari