Concatenating Row Values in SSRS?

Question

I'm trying to concatenate a particular record into one field to avoid multiple rows for the record. The issue is that a drive may contain multiple shifts in which each shift may be assigned a different vehicle.

Screenshot below shows what is happening: enter image description here

Both records show the same drive, but the two shifts. I'd like to get the vehicles column to concatenate all vehicles into one field (Vehicles).

My attempt at an expression is:

=Fields!ShortDesc.Value & "," & Fields!ShortDesc.Value

Which obviously isn't working. Any suggestions on what to do to get this working correctly?

Which database are you using? – Atilla Ozgur Feb 16 '15 at 21:57 — Atilla Ozgur, Feb 16 '15 at 21:57
I am sorry, I updated my tags but it is MS SQL 2008. – MISNole Feb 16 '15 at 22:11 — MISNole, Feb 16 '15 at 22:11

score 2 · Accepted Answer · edited May 23 '17 at 11:53

2

Easy solution would be to concat in database layer. See following question and answer. If you need to use SSRS solution, answer is running value function, an example here.

edited May 23 '17 at 11:53

Community

1
1

answered Feb 16 '15 at 22:20

Atilla Ozgur

14,339
3
49
69

Thanks, I'll try to do this on the DB layer. – MISNole Feb 17 '15 at 16:37

Concatenating Row Values in SSRS?

1 Answers1