How to split multivalue parameter that is already contains comma in ssrs reports -


i have ssrs report multivalue parameters jobtitle. jobtitle contains ','.

so, how split multivalue parameter?

for example, have records :

responder,supervisor,field distributor 1,worker,field distributor 

i want:

  1. responder
  2. supervisor,field distributor 1
  3. worker,field distributor

i assuming want split @ each comma. used expression =fields!jobtitle.value.tostring().replace(",",vbcrlf)to this

enter image description here


Comments