Reporting Services is displaying extra rows for minimised row groups

Posted by Graphain on Stack Overflow See other posts from Stack Overflow or by Graphain
Published on 2010-06-03T09:35:07Z Indexed on 2010/06/07 2:02 UTC
Read the original article Hit count: 372

Hi,

I have a fairly basic SQL Server Reporting Services report that is using nested row groups. Each sub-group depends on expanding its parent to be visible which is all pretty standard. The layout is something like this:

{      Company
{ {      Car  SUM(Price)
{ { {      Part  Price

My desired result when expanded is something like this (which I get fine):

- SuperCarCompany
  - SuperCar 20
     Door 20
  - SuperCar2 70
     Door 30
     Window 40
- OtherCarCompany
  - SuperCar2 50 /* Same SuperCar2 */
    Door 50
- MoreCarCompany
  - BestCarEver 535
     Engine 500
     Door 30
     Window 5

And when opened initially something like this:

+ SuperCarCompany
+ OtherCarCompany
+ MoreCarCompany

However, I'm getting this:

+ SuperCarCompany
 + SuperCar2 70 (i.e. sum of all SuperCar2)
+ OtherCarCompany
 + SuperCar 20
+ MoreCarCompany
 + BestCarEver 535

and I can even expand these superfluous rows like this:

+ SuperCarCompany
 - SuperCar2 70 (i.e. sum of all SuperCar2)
    Door 30 (i.e. first child of any SuperCar2)

The superflous rows dissapear immediately when I expand the expected row above it (i.e. I'd need to expand all expected rows to get rid of all superflous rows).

Any idea on the cause?

© Stack Overflow or respective owner

Related posts about reporting-services

Related posts about ssrs