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:
When adding group row for staffcode, checkbox for Group Header.