need to display Multiple value parameter

Hi, I am new to Birt and I have an urgent question regarding one report.

I have a report with one cascade report parameter (client and part number).
Client parameter can only have one value.
Part Number Parameter can have multiple values.

my question is how to display the part number parameter ? I tried to display it on a grid but got a "bad" text : "[Ljava.lang:Object;@62867c"

Please advice how to solve this issue.

Thx

Find more posts tagged with

Comments

Virgil Dodson

Hi ciamikbener, 
 
It looks like this is an enhancement that is slated for BIRT 2.5 
 
<a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=208477'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=208477</a>

Nilesh

Hi,

Choose List box to allow multiple select........Then you have to write javascript
to separate the Multiple values...

Thanks.

LetsBIRT

Nilesh,
Can you please give us a sample code for that.

Thanks

cypherdj

LetsBirt, 
 
the script I sent you last week does exactly that, rather than using the IN filter. The benefit of using scripting in this case is that you don't fetch rows to weed them out afterwards, so the performance of your report should be improved. The downside is, it's much harder to visualise the query, so people usually add some logging. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
prmWorkTypes = params["rpt_workTypes"].value;

if (prmWorkTypes!=null && prmWorkTypes!="") {
this.queryText = this.queryText
+ " WHERE workType IN (" + concatMultiSelectValues(prmWorkTypes) + ")";
}

function concatMultiSelectValues(valuesArray) {
var concatValues = "";

for (idx=0; idx < valuesArray.length; idx++) {
concatValues = concatValues.concat(valuesArray[idx] + ", ");
// string version
// concatValues = concatValues.concat("'" + valuesArray[idx] + "', ");
}

// remove last ", "
concatValues = concatValues.substr(0, concatValues.length - 2);

return concatValues;
}
</pre>
 
hoping that helps, 
Cedric

LetsBIRT

What i am trying to find out here is how to achieve this in the cascade parameters, as i do not see a multivalue select in cascade parameters. 
The user would like to have an option of selecting multiple parameters from the child or second level of paramter, once he selects the first one. 
Thanks

cypherdj

Hi LB,

multi-selects are not supported as cascading parameters in Birt 2.2.2

I know this feature is definitely in the pipeline at some point, but not sure if it's part of the 2.3 release.

Since I've implemented my own viewer, I could get round this problem by using report parameters and group parameters, but if you're using the 2.2 BirtViewer, I'm afraid this cannot be done AFAIK.

LetsBIRT

OK.
Thanks.

LetsBIRT

Cedric, 
The multi select actually works. 
All that i did was, go to the Advanced Properties of the cascaded parameter(second level) and i was surprised to see a multi-value option in the Property "Scalar parameter type". and that's that. 
I dont know why woudnt they just put it on the creating of the new cascade parameter page itself. 
 
Thanks...LB

cypherdj

Wow, indeed, thanks for the info! I'll have to try this out at some point.