Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

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

0
chrisryhal
Asked:
chrisryhal
  • 2
1 Solution
 
Brendt HessSenior 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now