sql server reporting services: concatenating strings like summing numbers -- sql server reporting services

concatenating strings like summing numbers

Max
11/11/2004 6:11:02 PM

sql server reporting services:

I'd like to join string within a group, preferable with a separator, the same
way I'd sum values.

So, I'd like to write somethign like
=Join( Fields!Email.Value, ";" )
to obtain a string of semicolon separated substrings, the same way I'd say
=Sum( Fields!Number.Value) to get the sum of numeric field.

Does anyone know a way to do this?

RE: concatenating strings like summing numbers

Dmitri
12/16/2004 1:13:03 AM

Having exactly the same problem. Thought of writing custom code, but not sure
what arguments to pass. The code had an array of strings as an argument, but
when i called the function the same way I would call an aggregate, got an
error message saying that aggregates can take only numeric values as
arguments..

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.