SSRS Expression Error

Below expression is saying there is an error somewhere after my "RIGHT"

"Operation '+' is not defined for types 'String'


="D00" + Fields!BANKACCTNUM.Value + Right("0000000000" + Fields!CHECKNUM,10)

Open in new window

LVL 2
chrisryhalAsked:
Who is Participating?
 
Brendt HessConnect With a Mentor Senior DBACommented:
If you have received this error, you're creating a .Net proc.  To concatenate strings, replace the + with an &, like this:

="D00" & Fields!BANKACCTNUM.Value & Right("0000000000" & Fields!CHECKNUM,10)

0
 
chrisryhalAuthor Commented:
Same error
0
 
chrisryhalAuthor Commented:
My fault, i didn't place the .VALUE on the Fields!CHECKNUM
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.