I have a formatting question regarding the expression below

The lookup set yields multiple Intervention Types with multiple comment reasons

The results currently displays as follows:

=Join(LookupSet(Fields!Account_Number.Value,Fields!Account_Number.Value, Fields!Intervention_Type.Value, "Interventions") , vbcrlf & Join(Lookupset(Fields!Account_Number.Value,Fields!Account_Number.Value,Fields!Intervention_Comment.Value, "Interventions"), vbcrlf))

Thank you in advance

Hi MLOG, 

According to your description, you want to format the text box, right? 

In Reporting Services, we can use "VbCrLf" to format the strings. For you requirement, please refer to the following expression:

="111" + VbCrLf + "222" + VbCrLf + "333" 

The result is like below: 

If you have any other question, please feel free to ask. 

Regards,
Shrek Li

Hi MLOG,

Try this

=Fields!YourColumn.Value.ToString().Replace(".",vbCrLf)