开发者

SSRS Sum in table group

开发者 https://www.devze.com 2023-03-11 04:56 出处:网络
I am working on SSRS repor开发者_开发问答ting services. I have a table on which I applied group. Originally I had this data:

I am working on SSRS repor开发者_开发问答ting services. I have a table on which I applied group. Originally I had this data:

SSRS Sum in table group

I changed something in my tablix and created a tablix and added a parent group of Age i.e. left column and then in the right column, I applied an expression: =SUM(Fields!AgeTotal.Value, "Group1") which made the result like this:

SSRS Sum in table group

Now I want 3,3,3 and 2,2 not to repeat and make them 1 row of each group. Like this:

SSRS Sum in table group

UPDATE:

SSRS Sum in table group


Right Click on the details cell and select add Total, then right click on the entire details rows and change it's visibility to Hide. This should do the trick!

EDIT

Setp by step tutorial with Image:

First image example: on the left the result you want, on the right the result you get from a simple grouping.
I'm getting the sum(but you could use a count or whatever aggregation you want) of the field lam_larghezza (which, for your information, is a width) group by different lam_spessore values (which, is a thickness)

I'm sorry but mi IDE is in Italian so here a simple translation:

Aggiungi -> Add
Gruppo -> Group
Righe -> Rows
Raggruppa per -> Group By
Totale -> Total
Dividi Celle -> Split Cell
Visibilità Righe -> Row visibility

SSRS Sum in table group

Let's start!

Create the dataset for the report and clean the report

Add a table to the report

SSRS Sum in table group

Add the detail field in the data row

SSRS Sum in table group

Right click on the full row
Add group -> Row group -> father group -> group by grouping field (should be age)

SSRS Sum in table group

SSRS Sum in table group

Click on the detail cell (only the cell not the entire row, and remember that the cell had to be highlighted not the text inside the cell, because two different contex menu appear) -> Add Total

SSRS Sum in table group

You now have 1 grouping cell and two detail cell

split the grouping field cell

SSRS Sum in table group

set the visibility of the detail row to hidden

SSRS Sum in table group

And you are done!

SSRS Sum in table group

0

精彩评论

暂无评论...
验证码 换一张
取 消