Force a default value for cascading parameter

Yann

Dear all,

As mentionned in title of the topic,

I have 1 casacading parameter encompassing 2 parameter.
I'd like to set a defaut value ("ALL") for the second parmeter.

However, each time a value is selected on the first parameter, the second parameter changes and the default value disappears for the second parameter.

Is there a way to fix this ? thank you in advance

cypherdj

Yann,<br />
<br />
I would say the easiest way would be to ensure that the "All" value in parameter2 is associated with each value for parameter1.<br />
<br />
So in your dataset for parameter2, you could do:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
select 0, 'All' from param2table
union
select param2value, param2display from param2table
</pre>
<br />
See the attached example I built with the classicmodels sample database, using the default value 0 for parameter2 (obviously, if 0 is already in the returned values in your select, use whatever other value you know is not going to conflict).<br />
<br />
I hope that does what you're looking for,<br />
Regards,<br />
Cedric