Set Parameter default value automatically from Dataset

Piero

Hello

I have a dynamic Parameter (hidden and required).
The resultset from the Dataset has always only one row. How can I fill the
default-value of the parameter automatically with this result?

Thanks
Piero

RichT

Hi,<br />
<br />
In the onFetch event of the dataset you can say something like...<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>params["NewParameter"].value = row["COLUMNNAME"];</pre>
where NewParameter is the name of the parameter you want to assign the value to and COLUMNNAME is the name of the column in the result set. The only problem you may run into is that this event may occur too late in the processing for you to use the new parameter value where you are needing it. <br />
<br />
Hope this helps,<br />
Rich