Pass multiple values to Dataset

nav33n89

Hi,<br />
<br />
I want to pass multiple values to dataset... <strong class='bbc'>string, date, date </strong>to execute a dataset(stored procedure)<br />
<br />
<br />
I do this in a script on layout<br />
<br />
<strong class='bbc'>window.location = window.location + '&EquipName=' + val + '&StartDate=' + strtDate +'&EndDate=' + eDate;</strong><br />
<br />
and in beforeOpen method of dataset I have :<br />
<br />
this.setInputParameterValue("@eqName&quot;, params["EquipName"]);<br />
this.setInputParameterValue("@StartTimeUTC&quot;, params["StartDate"]);<br />
this.setInputParameterValue("@EndTimeUTC&quot;, params["EndDate"]);<br />
<br />
but when I preview... I get the following exception<br />
<br />
The following items have errors: <br />
<br />
<br />
ReportDesign (id = 1): <br />
+ There are errors evaluating script "<br />
this.setInputParameterValue("@eqName&quot;, params["EquipName"]);<br />
this.setInputParameterValue("@StartTimeUTC&quot;, params["StartDate"]);<br />
this.setInputParameterValue("@EndTimeUTC&quot;, params["EndDate"]);<br />
<br />
":<br />
null. (Element ID:1) <br />
<br />
<br />
PFA my file

kclark

Have you tried the report without setInputParameterValue() in the before open? It looks like you've already set the parameters in the dataset UI.