SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a multi-select box with 15-20 values in it corresponding to SharePoint users. The problem I'm having is that for every entry in the Multi-Select box that is not chosen, a new line or blank line placeholder gets placed in the output. So when I'm pulling this stuff into SSRS, I'm getting a bunch of empty lines and Trim, LTrim, RTrim aren't working. Tried replacing VBCRLF with "", and a bunch of other stuff with no luck. Here is what the output looks like:

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.