cascade parameters with default values

pjmcosta

<p>Hello, i have a report with 5 cascade parameters, and i have default values on it (all records).</p>
<p>when the parameters form loads they are ok with defaults value on selected on the combo box.</p>
<p>After changing the second parameter they are removed from each parameter combo box , and we need to choose each value one by one.</p>
<p>Is there any way of setting the default value off the combo box to "all" , to allow the user to choose only the specific parameters and not all off them.</p>
<p> </p>
<p>Thanks in advance</p>
<p>Paulo</p>

Channamari

<p>As far as i understood your problem, In your query of the dataset you can do this by adding "union select 0,'All' from dual".. Add 0 as the default value for the parameter.. I hope this is what you wanted..</p>