I found the way to use Multi select Clarity report parameter in Crystal report
Create a parameter in Crystal report with "Allow Multiple values" set to True in parameter properties
Create a DB function to split string
create or replace type split_number_tbl as table of number;
create or replace function split_numbers
(
p_list varchar2,
p_del varchar2 := ','
) return split_number_tbl pipelined
is
l_idx pls_integer;
l_list varchar2(32767) := replace(replace(p_list,'(',''),')','');
l_value varchar2(32767);
begin
loop
l_idx := instr(l_list,p_del);
if l_idx > 0 then
pipe row(substr(l_list,1,l_idx-1));
l_list := substr(l_list,l_idx+length(p_del));
else
pipe row(to_number(l_list));
exit;
end if;
end loop;
return;
end split_numbers;
/
In crystal report the query should be like this
select id,code,name
from inv_investments
where id in (select * from table(split_numbers('{?param_project}',',') ) )
I did this for numbers list, you can do similar for list of characters.
Enjoy.