Search code examples
sqlreportreportingservices-2005

Is there a way to have the Staff Code and Name on a Single Row in an SSRS table


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.

enter image description here

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:

enter image description here

If i add child_code to the row grouping under staff_code, it creates a Client_code column and I dont want a column:

enter image description here


Solution

  • When adding group row for staffcode, checkbox for Group Header.