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 an InfoPath 2010 form promoting fields to SP 2010. Using SSRS 2008 R2, I'm pulling those fields into a report to report off of. I'm finding that some fields in the ows_MetaInfo blob have a carriage return prefixed on them, in the format:


This is preventing the use of filters in SSRS as SSRS is seeing the "blank" line preceding the value as the value for the item. How can I remove this carriage return on the InfoPath/SharePoint side, or deal with it on the SSRS side?

share|improve this question
up vote 0 down vote accepted

I ended up solving this within the reports using the code:

Public Function StrStrp(str As String) As String
    str = str.TrimStart(Chr(10))
    Return str
End Function
share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.