Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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:

FieldName:SW|\nFieldValue

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.