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

score 18 · Answer 1 · edited Aug 19 '15 at 04:43

18

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.

edited Aug 19 '15 at 04:43

Jeremy Thompson

61,933
36
195
321

answered Jan 21 '10 at 15:35

Grubsnik

918
9
25

Hide duplicates did not work for me. But I added both fields to the initial grouping, and the 2nd grouing has the 2nd field again... this seems to work. – CodeGrue Sep 02 '10 at 13:05
2

This worked for me. In the above question, you would click the little down arrow to the right of the parent group in the Row Groups window then choose Group Properties, then click Add under Group expressions and choose the name of the sub group and click OK. – A. Murray Sep 30 '15 at 09:04

score 5 · Answer 2 · answered Sep 03 '14 at 13:44

5

It's so simple...you have to right click on the cell in the DATA area (ex. where is displayed the value 500) and to click add COLUMN on the left. After this change the value in the new cell with the label field (subgorup1), also do this for the others columns that you want to add, but remember to do it from the DATA area. when you finish, delete the columns out of the data area, but keep the row groups. nice try!

answered Sep 03 '14 at 13:44

Gerard

51
1
1

Best answer, took me 10 seconds:) – Rogier Wijsman Aug 18 '15 at 10:50
Will the solution works if we have toggle enabled on the main group ? – Navneet Sharma Jul 23 '20 at 14:30

score 4 · Answer 3 · answered Oct 24 '13 at 21:26

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.

score 1 · Answer 4 · answered Sep 08 '09 at 20:54

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.

answered Sep 08 '09 at 20:54

Hide Duplicates "None" seems to be the default. – CodeGrue Sep 02 '10 at 12:58

score 1 · Answer 5 · answered Dec 02 '11 at 12:47

I had this same issue and I solved it really easily.

It seems you have two row groups, by group and by subgroup.

What you have to do is to select the first column and group by group and by subgroup and remove the grouping by subgroup.

That should do the trick.

score 0 · Answer 6 · edited Feb 05 '20 at 07:34

0

Put ROW_NUMBER() OVER (ORDER BY name ASC) AS Row# in each query as a serial number and hide the row in the SSRS Report.

See: https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver15

edited Feb 05 '20 at 07:34

geisterfurz007

5,292
5
33
54

answered Feb 05 '20 at 07:26

user2450592

1

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

6 Answers6

Linked