Ask Your Question

Does Report Builder have a concatenate formula/function? [closed]

asked 2014-02-09 23:25:45 +0200

MikeM gravatar image

I've been trying Report Builder and it seems quite a bit more stable than the last time I gave it a try, which is wonderful - thanks to all the people at LO for that!

Now I'm trying to do a production report and would like to concatenate fields, such as first + last, or city + state + zip. However, I can't get anything to work. Since there's also not a CONCATENATE function listed in the wizard, I wonder if this is possible?

I've tried all combinations I can think of with single or double quotes, () or [] as fieldname qualifiers, and the "||" operator as well as the concatenate keyword... nothing works.

Having to do all of the variations I may need in SQL is tedious in that it means different views for differently formatted output... which seems like tying "content" and "presentation" together way too closely.

Any help appreciated! PS: I've googled the heck out of it, just for the record :-)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 09:34:22.540844

1 Answer

Sort by » oldest newest most voted

answered 2014-02-10 02:53:03 +0200

horst gravatar image

It works like that: [first]&" "&[last].

edit flag offensive delete link more



Thank you!!!! The ampersand -- how could I forget the ampersand ?!? I couldn't think of any other common operator symbols... my mind is betraying me! Thanks again, works great!

MikeM gravatar imageMikeM ( 2014-02-10 07:04:58 +0200 )edit

Question Tools



Asked: 2014-02-09 23:25:45 +0200

Seen: 3,670 times

Last updated: Feb 10 '14