Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Reporting Services string concatenation issue

I am trying to write an expression to concatenate a string but I get an error message when I save the report. What could be the problem? Thanks for any help.

=Fields!address.Value&","&Fields!city.Value&","&Fields!zipcode.Value&","&Fields!state.Value
like image 398
nav100 Avatar asked May 23 '12 18:05

nav100


People also ask

What happens when concatenating strings?

Concatenation is the process of appending one string to the end of another string. You concatenate strings by using the + operator. For string literals and string constants, concatenation occurs at compile time; no run-time concatenation occurs. For string variables, concatenation occurs only at run time.

What are the 2 methods used for string concatenation?

There are two ways to concatenate strings in Java: By + (String concatenation) operator. By concat() method.

Can you use += for string concatenation?

Concatenation is the process of combining two or more strings to form a new string by subsequently appending the next string to the end of the previous strings. In Java, two strings can be concatenated by using the + or += operator, or through the concat() method, defined in the java. lang. String class.


1 Answers

The .Value must be separated from the & with whitespace, otherwise it will not work.

like image 110
David Yenglin Avatar answered Nov 11 '22 09:11

David Yenglin