I have an SSRS Report which is having groups. I need left most rows to be repeated in the tablix for the group.
Example:
Original Report is like below
Country Region Category Total
------------------------------------------
Group Total 1000
Product 1 200
USA NORTH Product 2 300
Product 3 300
Product 4 200
------------------------------------------
Group Total 500
USA SOUTH Product 1 200
Product 2 300
------------------------------------------
But I want the report to be modified to be like below.
Country Region Category Total
------------------------------------------
USA NORTH Group Total 1000
USA NORTH Product 1 200
USA NORTH Product 2 300
USA NORTH Product 3 300
USA NORTH Product 4 200
------------------------------------------
USA SOUTH Group Total 500
USA SOUTH Product 1 200
USA SOUTH Product 2 300
------------------------------------------
We have a row level Group on CATEGORY column.