Capture parameter multi value with trim in Crystal Report

[former_member195446]

Hi Experts,

i have one parameter which is having multiselection in my report and need to capture the selected values

my paramters list of values are like below

Access Level1

Access Level2

Access Level3

Access Level4

if I selet Access Level1 and Access Level2,Access Level3 i need to show in the report header like Access Level1,2,3

i have used join condition to capture the selecetd value

Join({?Paramtername},",")

it showing like Access Level1,Access Level2,Access Level2 so i need to trim the numbers dynamically

Thank You,

Prasad

[abhilash_kumar · Accepted solution]

Hi Prasad,

If the word 'Access Level' is common for each value in the list, this should work:

"Access Level " & Replace(Join({?Parametername}, ', '), 'Access Level', '')

-Abhilash

[Former Member]

Hello Prasad,

Please use below code

stringVar array x := split(Join({?Paramtername},","),",");

Local numberVar i;

Local stringVar outputString := "";

For i:=1 to Count(x) do

(

outputString := outputString + mid(x[i],13,1)+","

);

"Access Level"+outputString;

regards

Niraj