Hello,
I am using the following expression to strip the last 11 characters in a field group and it returns an error saying that Len cannot use a negative number. It must be 0 or greater. Is there a better alternative?
Code Snippet
left(Fields!TestName.Value,len(Fields!TestName.Value)-11))
you can use Rtrim|||Are you always removing 11 character regardless of the field length or do you simply want to restrict it to a certain size?
For example, the following code restricts the length to 5 characters:
=iif(len(rtrim(Fields!TestDATA.Value)) > 5, mid(rtrim(Fields!TestDATA.Value),1,5), rtrim(Fields!TESTDATA.Value))
No comments:
Post a Comment