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
– Atilla Ozgur

2015-02-16 21:57:51 +00:00
Commented Feb 16, 2015 at 21:57 — Atilla Ozgur
– Atilla Ozgur, Commented Feb 16, 2015 at 21:57
I am sorry, I updated my tags but it is MS SQL 2008.

MISNole
– MISNole

2015-02-16 22:11:16 +00:00
Commented Feb 16, 2015 at 22:11 — MISNole
– MISNole, Commented Feb 16, 2015 at 22:11

Community · Accepted Answer · 2017-05-23 11:53:19Z

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, 2017 at 11:53

CommunityBot

11 silver badge

answered Feb 16, 2015 at 22:20

Atilla Ozgur

14.8k3 gold badges54 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MISNole Over a year ago

Thanks, I'll try to do this on the DB layer.

Collectives™ on Stack Overflow

Concatenating Row Values in SSRS?

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related