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; } } }

Listbox casscading parameter

angrishman

Hi..

I have used cascading parameter in my report.In last drildown option I put the multi select option to "True".

Now I have to pass this multiselect parameter in form of comma seprated value to "Procedure" Parameter.

I have used Procedure because it's conditional based.

So is it possible to pass this multi select parameter to "Stored Procedure."

Kindly Suggest.

Find more posts tagged with

Comments

mwilliams

In the dataSet that you're wanting to use this, just edit your stored procedure using the queryText property in the beforeOpen method. To pass the value as a comma separated list, you'd just join the parameter values like:

params["myParam"].join(",");

angrishman

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108255" data-time="1344360049" data-date="07 August 2012 - 10:20 AM">
In the dataSet that you're wanting to use this, just edit your stored procedure using the queryText property in the beforeOpen method. To pass the value as a comma separated list, you'd just join the parameter values like: 
 
params["myParam"].join(","); </blockquote>
 
 
 
 
Hi William, 
 
I have implemented it like mentioned below- 
 
On "beforeOpen" Event of the DataSet-- 
 
 
" 
 
importPackage(Packages.java.io) 
 
valStore=""; 
var parameterArray = reportContext.getDesignHandle().getAllParameters(); 
var sParName = parameterArray.get(3).getFullName(); // My third parameter is Multiselect listbox(Store) 
strParamValsSelected=reportContext.getParameterValue(sParName); 
 
if (strParamValsSelected.length > 0 ) 
{ 
for (i = 0; i < strParamValsSelected.length-1; i ++ ) 
{ 
if(valStore="") 
{ 
valStore = reportContext.getParameterValue(sParName); 
} 
else 
{ 
valStore=valStore+","+reportContext.getParameterValue(sParName); 
} 
 
} 
 
} 
params["prmstore"]=valStore; 
this.setInputParameterValue("prmStoreId",params["prmstore"]); 
 
 
But the problem in the above code is that it is looping through all the Items in the ListBox but what i require only selected value of that store. 
 
so i have to populate only selected values of the listbox items. 
 
 
Kindly suggest or correct me if i missed something in the above code. 
 
Regards, 
Sumit sharma

mwilliams

You could put a static value into your stored procedure query, in the dataSet editor and then in your beforeOpen script, do something like:

this.queryText = this.queryText.replace("myStaticValue",params["myMultiSelectParam"].join(","));