APEX

Dear fellow developers!

After struggling hours and trying virtually endless ways, it's time to contatct you.

I have a multi select list item and would like to pass selected values to the JasperReport parameter called "myCollection", which is used in a where clause within the report:

WHERE  NVL(S.ARBEITSSCHRITT,-1) != 0 and S.AREA in $P{myCollection}

The report however remains blank whenever I try to pass more than one value!

In fact I also tried to declare the JasperReports parameter to be of type "Collection" and used the following syntax to pass the values:

WHERE  NVL(S.ARBEITSSCHRITT,-1) != 0 and  $X{IN,S.GEBIET,myCollection}

In that case I receive the following JasperReports error message

Error: Incompatible java.lang.String value assigned to parameter myCollection 

Could you possibly advise me how to pass several alphanumeric parameters as a string to Jasper?

This is one of my current code:

declare
myParam varchar2(32000);
BEGIN

select translate(:P3_SELECT, ':', ',') into myParam from dual;

  xlib_jasperreports.set_report_url('http://10.22.52.65:8080/JasperReportsIntegration/report');
  xlib_jasperreports.show_report (p_rep_name =>   'n2000_pm_overview',
                                  p_rep_format => :P3_PRINTER_OPTIONS,
                                  p_data_source => 'n2000',
                                  p_out_filename => 'My_Report_name' || '.' || :P3_PRINTER_OPTIONS,   
                                  p_rep_locale => 'de_DE',
                                  p_rep_encoding => 'UTF-8',
                                  p_additional_params => '&myCollection=' || myParam);

  -- stop rendering of the current APEX page
  apex_application.g_unrecoverable_error := true;
end;

A million thanks for your help!