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.

Answer 2

Currently, what I've found to be a good way of determining whether or not the repeated values of a group would show up in a SSRS report, is to create the Groups and build your report based on the groupings. Secondly, take the groups fields and duplicate the column to the right hand side of the report. Making sure that you've included all the columns needed and totals are correct; delete the grouped columns. When you do this, you will get a popup asking if you want to delete the group or just the columns, chose columns - this will keep the format of the initial report and keep all of the total line as well.