Warm tip: This article is reproduced from serverfault.com, please click
Is there a way to have the Staff Code and Name on a Single Row in an SSRS table
发布于 2020-12-09 15:43:17
Is there a way to have a table in SQL Server Report Builder (its the only version of SSRS i have the option of using) that looks like the below?
I am grouping by Parent Group: staff_code and Child Group: Client_code. I cannot get the staff_code and Staff_name on its own row, and cannot get the Client_code and Client_Name on its own row and still have the grouping work.
The only way i can get it anywhere close is like this, but it keeps repeating the Staff Code and Name on each line for each client:
If i add child_code to the row grouping under staff_code, it creates a Client_code column and I dont want a column:
Questioner
Dee
Viewed
0
