Displaying Result

hi there,

is there any way in populating data like the example below using Reporting Services?

SQL database table result:

Category Name

Group 1 John

Group1 May

Group2 Mary

Display in Report

Group 1 Group2

John, May Mary

regards

angela

Hi Angela

If you want the array of names to be shown next to
each other in instead of having to itterate for each item
in the group you could do the following.

Create a table report with 'group' as the group
and 'Name' as detail

In the expression for name you can the use the join function:

=JOIN(Fields!Name, " ")

This will append all the fields in the aggregation,
if you group by the 'group' field it should effectively
give only the names for that group, in the following formatt:

Group Name
-|
Group1 | Angela Johan Beckham |
--|-|
Group2 | Andre Jaco Peter |
--|-|

Hope this helps

Gerhard Davids

|||

Hi Gerhard Davids,

the solution u provide returns an error like this:

Overload resolution failed because no Public 'Join' can be called with these arguments:

'Public Shared Function Join(sourceArray As String(),[Delimiter As String = ] as string......

Regards

angela

|||

HiAngela

I'm sorry, I made a mistake: the join function is for
joining selected parameter arrays in a multi-selected
parameter. Your problem seems far more complex.

I am trying to find a solution for you, and I will let
you know as soon as I find one.

Sorry for not being more helpfull.

Gerhard Davids

|||

Hi Gerhard Davids,

Thanks 4 ur help, my problem has been solved..but was done in a very tedious way by writing the stored procedure.

regards

angela