We have successfully created and tested a report in Birt v. 2.2.2 using "single-value" input-parameters with our report-query.
We are now trying to use "multi-value" input parameters, but we have problems understanding how to embed the parameters into our query in a correct manner.
The following explains what we have done so far:
1) we created a query with one "?" (se query below)
2) we created one multi-value parameters in the "report paramaters" view named "testparameter" ("dynamic", "allow multiple values")
3) we created one input-parameter in the "edit dataset"-view named "testinputparamter" and set the "default value"-property to the previously generated parameter (see 2 above)
4) we then tried to preview the report, but then we received an errormessage that says "Can not convert the value of [Ljava.lang.Object;
@170a5ee to Integer type"
How can we create and use multi-value input-parameters in queries correct? It looks like the multi-value-parameter returns an object of type "object", but we need to access the actual selected values in our query..
Any feedback on this is appreciated. See our stripped down SQL-query (with parameter) below:
select
h.id as helseforetak_id, h.navn as helseforetak_navn, h.region_id as helseforetak_region_id
from
helseforetak h
where
h.id in (?)
;
