Getting the display text of each item in list box parameter.

Hi I'm using a list box type paramet in my report. 
I can take the value of each item selected in the parameter by params["sample"].value
And if it's just a combo box type parameter i can take the display text also from params["sample"].displayText
 
but when it's a list box type parameter how can i get the display text of each item selected?
 
I followed this question also but couldn't find a proper answer to my question.
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/19869-displaying-label-of-dynamic-parameter-list-box-in-report/'>http://developer.actuate.com/community/forum/index.php?/topic/19869-displaying-label-of-dynamic-parameter-list-box-in-report/</a>
 
I tried these methods but it gave errors. Is this not possible in BIRT?
 
params["sample"].value[0].displayText
params["sample"].displayText[0]
params["sample"].displayText

Find more posts tagged with

Comments

JFreeman

Multi-select parameters are stored in a java.lang.object.
It looks like you will need to pull the value into a new variable in order to access the values of the object from an index.
For example:
<pre class="_prettyXprint _lang-js">
var myParam = params["myParam"].value;
for(var x=0; x<myParam.length; x++){
Packages.java.lang.System.out.println(myParam[x]);
}
</pre>

newbie1

Hi,
 
I ran into error when ran the above set up:
 
A BIRT exception occurred. See next exception for more information. TypeError: Cannot read property "length" from null (/report/data-sets/oda-data-set[@id="2194"]/method[@name="onFetch"]#27)
 
My Multi-value parameter is optional and when user leaving the parameter blank....I got the above error and the report does not work. 
When the user chose a value for this parameter, the report run successfully but the parameter value did not display.
Any help is greatly appreciate.

JFreeman

For the first part, you will need to put a null check in if the parameter is optional and could have a null value.
 
Can you provide a sample report that demonstrates the behavior of the parameter value not displaying?

newbie1

Here is my sample report:
 
When I run with a value for the parameter....it works, when I ran with empty parameter this is the error I got:
 
org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if(params["p_param"].value.length == 'null') { sttsList = 'NULL'; } else { p_lngth = params["p_param"].value.length; for (i=0;i { 
if (params["p_param"].value == row["PRODUCTCODE"]) 
{ 
paramList = paramList.concat(row["PRODUCTNAME"]); 
if (i { 
paramList = paramList.concat(", "); 
} 
} 
} 
}": 
Fail to execute script in function __bm_onFetch(). Source:

" + if(params["p_param"].value.length == 'null') 
{ 
sttsList = 'NULL'; 
} 
else 
{ 
p_lngth = params["p_param"].value.length; 
for (i=0;i { 
if (params["p_param"].value == row["PRODUCTCODE"]) 
{ 
paramList = paramList.concat(row["PRODUCTNAME"]); 
if (i { 
paramList = paramList.concat(", "); 
} 
} 
} 
} + "

A BIRT exception occurred. See next exception for more information. 
TypeError: Cannot read property "length" from null (/report/data-sets/oda-data-set[@id="407"]/method[@name="onFetch"]#1).)>;i++)>)>;i++)>
 
My report has a Multi-value parameter that is optional (courtesy of "bluish", last post from, <a class="bbc_url" href="http://stackoverflow.com/questions/3402148/how-do-i-set-a-parameter-to-a-list-of-values-in-a-birt-report">http://stackoverflow.com/questions/3402148/how-do-i-set-a-parameter-to-a-list-of-values-in-a-birt-report</a>). 
 
There are scripts in the: Initialized section of the Report; beforeOpen of the DataSet1 and onFetch of the paramlist dataset.

newbie1

JFreeman

I believe this has to do with how you are performing the null check.
If no value is selected, then the value of the parameter is null which means you cannot perform a length check which is causing the errors.
 
Instead, change your null check to something like this:
<pre class="_prettyXprint _lang-js">
if(!params["p_param"].value)
</pre>

newbie1

OMG.....it works.....
 
I changed to this:
if(!params["p_param"].value) { paramList = 'NULL'; } else { p_lngth = params["p_param"].value.length; for (i=0;i { if (params["p_param"].value == row["PRODUCTCODE"]) { paramList = paramList.concat(row["PRODUCTNAME"]); if (i { paramList = paramList.concat(", "); } } } }
Thank you. Also, can you please tell me why this if(!params["p_param"].value) works and this query that I did if(params["p_param"].value == 'null') do not ?

JFreeman

It is going to have do with how javascript handles empty values.
In this situation, it probably isn't actually reporting as 'null' but instead is 'undefined'.
 
Take a look at the W3 page on data types for more details on null vs undefined in javascript: <a data-ipb='nomediaparse' href='http://www.w3schools.com/js/js_datatypes.asp'>http://www.w3schools.com/js/js_datatypes.asp</a>
 
Using the not operator (!) will report the same for both situations which can be a bit of a double edged sword depending on the situation. However, for this case I think it should be fine.