reporting-servicesssrs-grouping

Why would SSRS have 2 instances of a top-level group?

In a report with two levels of grouping, I have a top-level group that is repeating. This is apparent in the report on the left-hand navigation bar/document map but also when exporting to Excel, it splits to two worksheets (with the same name!) and shows on separate lines in the document map tab. E.g.

UNIT A
  person 1
  person 2
  person 3
UNIT B
  person 4
  person 5
UNIT B
  person 6

The desired behavior is 

UNIT A
  person 1
  person 2
  person 3
UNIT B
  person 4
  person 5
  person 6

Any ideas for why the group would be splitting?

Solution

  • SSRS only changes group if there is a difference in value.. ensure there are no hidden characters or the likes in the UNIT B group.