Fai la tua domanda

MikeM's profile - attività

2020-05-05 16:25:07 +0200 received badge  Buona domanda (source)
2020-02-01 14:01:34 +0200 received badge  Tassonomista
2015-05-08 15:40:41 +0200 received badge  Studente (source)
2015-05-08 15:40:12 +0200 received badge  Domande famose (source)
2014-02-16 22:43:00 +0200 received badge  Domanda notevole (source)
2014-02-10 10:18:46 +0200 received badge  Domanda gettonata (source)
2014-02-10 07:04:58 +0200 ha commentato una risposta Does Report Builder have a concatenate formula/function?

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!

2014-02-09 23:25:45 +0200 ha posto una domanda Does Report Builder have a concatenate formula/function?

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 :-)