problem passing list of values from multiselect listbox

Hi All, 
 
As I am new to Birt and am creating a simple report from the Birt Designer Tool from Eclipse. The scenario is somthing like this I have a dataset whose values are being populated from a Oracle Stored Proc having three input parameters and one output parameter(ref cursor). Out of the three input paramater, one parameter is a multiple value parameter from a multi valued List Box, which is being used in my Stored Proc "IN" clause. The problem is that I am able to select multiple values from the List Box from the report but not able to bind it with the input parameter of my Stored Proc. 
 
I followed this topic 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/20427-pass-multi-value-parameter-to-database-stored-procedure/page__p__68084&'>http://www.birt-exchange.org/org/forum/index.php/topic/20427-pass-multi-value-parameter-to-database-stored-procedure/page__p__68084&</a> 
 
But I didnt able to get into a positive result with the above topic. 
If I use the way as mentioned above in the topic I got the below error: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>A BIRT exception occurred.
Plug-in Provider:Eclipse BIRT Project
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:3.7.2.v20120213
Error Code:data.engine.FailToExecuteScript
Error Message:Fail to execute script in function __bm_beforeOpen(). Source:

" + this.setInputParameterValue("I_LSA", params["lsa_list"].value.join("," ));
+ "

A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: TypeError: Cannot find function setInputParameterValue in object</pre>
 
Kindly suggest what am I doing wrong.

Find more posts tagged with

Comments

mwilliams

Take a look at this old post. Maybe it'll help.

http://www.birt-exchange.org/org/forum/index.php/topic/15248-cannot-find-function-setinputparametervalue/

Can you attach your design?

javadev20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109188" data-time="1347381670" data-date="11 September 2012 - 09:41 AM">
Take a look at this old post. Maybe it'll help. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/15248-cannot-find-function-setinputparametervalue/'>http://www.birt-exchange.org/org/forum/index.php/topic/15248-cannot-find-function-setinputparametervalue/</a> 
 
Can you attach your design? </blockquote>
 
 
Thanks Williams, for your reply and the topic that you refer is very helpful in correcting out my issue. 
I managed to pass multi value parameters in my Stored Procedure by the method that you have mentioned in the above topic. 
I just want to highlight the thing that I am doing wrong is that, in my SP I am using a IN clause under where condition for comparing the values that I have taken from the multiple value list parameter which is wrong. Under such circumstances, if we want to pass multiple values from report parameters to the SP we have to use a condition in the SP something like this 
<pre class='_prettyXprint _lang-auto _linenums:0'>where instr(sp_input_param, ','||table_column||',' ) > 0</pre> instead of <pre class='_prettyXprint _lang-auto _linenums:0'>where table_column IN (sp_input_param)</pre>. 
Also we have make sure that the first and last character in the list obtained from the multi valued report parameter is a comma (','), which is being managed by <pre class='_prettyXprint _lang-auto _linenums:0'>inputParams["sp_input_param"]="," + params["multi_value_list_report_param"].value.join(",") + ",";</pre> under the beforeOpen method of the dataset. 
 
Thanks

mwilliams

Glad you got it working. Let us know whenever you have questions!