CODEWITHSUNDEEP
ssrs-2008ssrs-2008-r2ssrs-tablixssrs-grouping
Jay
Jay

Reputation: 465

SSRS Row Grouping help needed please

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!

Upvotes: 0

Views: 91

Answers (2)

Flying Turtle
Flying Turtle

Reputation: 364

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.

Upvotes: 0

pancho018
pancho018

Reputation: 587

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.

Upvotes: 1

Related Questions