question

Geets avatar image
Geets asked

How to convert multiple rows into one row in SSRS?

My sql query shows the data of Employee Hierarchy with the authcodes like this- ManagerName EmployeeName AuthCode Tim Peter csr2 Tim Peter sup Tim Peter itil Tim Colt csr2 Tim Colt sup  The SSRS report shows the results like this, when I chose the report parameter= Tim, the result only shows the top line and not the subsequent AuthCodes whereas the query shows all EmployeeName AuthCode Peter csr2 Colt csr2  I want the data to show like(it should concatenate the authcodes for the employees): EmployeeName AuthCode Peter csr2, sup, itil Colt csr2, sup Could anyone please suggest what I need to do in SSRS so that the data shows all the authcodes with comma separated values? Thanks
sql-server-2008pivotssrs-2008-r2group-by
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
jason_clark03 avatar image
jason_clark03 answered
Try this one it may be helpful to you. =Join(LookupSet(Fields!Company.Value & Max(Fields!Year.Value) , Fields!Company.Value & Fields!Year.Value , Fields!SubCert.Value , "DataSet1"), ",")
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This isn't answer to my question- @jason_clark03
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.