SSRS 2008 Grouping vs SSRS 2005

• suri.yalamanchili

  SSCommitted

  Points: 1645

  More actions

  March 19, 2012 at 2:27 pm

  #391822

  Hi All,

  I worked with SSRS 2005 and SSRS 2008. The problem I am facing is grouping. In 2005 if the group was collapsed (just the parent shown) , all the items inside the group would have been one under the other.

  In 2008 there is a large space (which is what the detail would occupy if expanded) and then the next parent group header starts.

  How do I change its behavior such that the list in the group come one under other and not after the space , when collapsed.

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  March 20, 2012 at 12:25 am

  #1461455

  The extra space is there for subtotals.

  For example, take a look at the example report at the bottom of this blog post:

  Your First OLAP Report[/url]

  But it is possible in SSRS 2008:

  Creating Stepped Reports with SSRS 2008[/url]

  Another option is using parent-child hierarchies:

  Using Analysis Services Parent-Child Hierarchies in Reports

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP