SSRS Row Grouping help needed please

Question

I'm guessing this is very simple but I am missing something and need help please.

My dataset looks like:

 CITY         STREET      HOUSES
 Norton       Main St     10
 Newton       Main St     30
 Providence   Angel St    15
 Boston       State St    50

I created a row group which groups by Street, but I am still getting 2 rows broken down by HOUSE numbers. Like this

 STREET        HOUSES
 Main St       10
               30
 Angel St      15
 State St      50

How do I SUM(HOUSES) based on the STREET column? I want my output to look like this (using SSRS grouping not SQL)

 STREET        HOUSES
 Main St       40
 Angel St      15
 State St      50

Thanks in advance!

do you have a details group? – pancho018 Oct 15 '14 at 11:47 — pancho018, Oct 15 '14 at 11:47

score 1 · Accepted Answer · edited May 23 '17 at 12:27

1

remove the details group and enter your aggregate expression Sum(Houses) into the cell. this will then group on street as you are expecting and not return each row from the dataset.

its not completely unlike this question, but this one also had column groups.

edited May 23 '17 at 12:27

Community

1
1

answered Oct 15 '14 at 11:53

pancho018

587
8
21

Thank you! This worked and allowed me to sum the 2 rows properly – Jay Oct 15 '14 at 19:17

score 0 · Answer 2 · answered Oct 15 '14 at 13:58

You need to group by street, once you have that you will have the same data that you have right now. what you need to do next is right click on houses, add new row outside the group, and in one of those cells place SUM(HOUSES) (so inside the street group). once you have that you can delete your old row and play around with that. hope this helps, cheers.

SSRS Row Grouping help needed please

2 Answers2