CODEWITHSUNDEEP
sql-server-2008reporting-servicesssrs-2008
Kyle
Kyle

Reputation: 5547

Join parameter labels then separate by commas, join not working as expected

Current Code

="Project Groups: " + replace(join(Parameters!projGroup.Label )," ",", ")

Problem

Works fine if projGroup are one word. Ex: Group1, Group2, Group3.

My client has a change in requirement... Groups are no longer one word.

Ex:

Group A

This Group

That Group

I need Need this to Display: Group A, This Group, That Group

But it's currently displaying this: Group, A, This, Group, That, Group

Upvotes: 0

Views: 70

Answers (1)

Lamak
Lamak

Reputation: 70638

As far as I know, you don't need to use REPLACE, can't you just do the following?:

="Project Groups: " + join(Parameters!projGroup.Label,", ")

Upvotes: 3

Related Questions