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

Question

Hi folks, 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

If you select the row in question, there is a field called Hide Duplicates. Set this to nothing (null, space, etc) That should return the values you want.

Answer 2

IF the above answer doesn't work, you can simple 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.