sql server - SSRS: repeat tablix left-most row group value on each row

Question

I have a tablix in an SSRS 2008 report. It has two-level row groupings, and I'd like the value for the left-most grouping to continue to be displayed on each row. Eg, I get this:

group1  subgroup1  500.00
        subgroup2  250.00

... but I'd prefer...

group1  subgroup1  500.00
group1  subgroup2  500.00

I can't seem to find the option for this. Is it a strange thing to want?

Thank you, Bill

Answer 1

You can simply edit the upper reporting level, to be grouping on both groups at the same time, this will cause your desired behaviour.

I had to resort to this solution once, where "hide duplicates" didn't seem to achieve the desired result.