Cascade Parameter Help

JavaNep

Hi I have attached the following image for my requirement . If u look at the image there is a cascaded parmeter p_service order type and P_subtype:
What I want to achieve is once the p_service order is checked the respective P_subtype value should populate in the p_subtype list box not FROM DATASET but hardcoded value of p_subtype in script, according to selected p_Service type.
How can I Do this . Is there any other way ?
i tried sending global persistentVariable from initialize script to defaulValue list of the subtype param. but it gets null .
Please help!

Hans_vd

Hi,<br />
<br />
You could create a scripted data set that reads the p_service parameter value and hard code some values in an array, and then bind that scripted data set to the report parameter p_subtype.<br />
<br />
Just an example of how the scripted data set should look like (didn't test it):<br />
in the open put code like this:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>subtypes = [];
if (params["p_service"]=="Service1") {
subtypes[0] = "A";
subtypes[1] = "B";
subtypes[2] = "C";
}
else if (params["p_service"]=="Service2") {
subtypes[0] = "D";
subtypes[1] = "E";
}
idx=0;</pre>
<br />
then in the fetch put code like this:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if (idx < subtypes.length) {
row["subtype"] = subtypes[idx];
idx++;
return true;
}else{
return false;
}</pre>
<br />
Regards<br />
Hans