SSRS 2008 add additional group

Posted on 2014-07-15
Last Modified: 2014-08-11
I have a report that has 2 groups already - campaign and within campaign the report category.  I need to add a 3rd level group so it will be subgroup then campaign and then report category.  I have tried adding another group multiple ways - added a row group, column group, above and below groups but nothing ever gives me what I need.  At best it created a group, but it is within the campaign group so I can't get my 3rd subtotal.  

I've done a few print keys of what it looks like currently and what it looks like when I added a group (and how the group was added).  I'm hoping someone can tell me how to add this outer group successfully. All of the cells have calculated fields so I don't want to create all of those.  (The print key only shows part of the report.)
Question by:cindyfiller
    1 Comment
    LVL 13

    Accepted Solution

    Rather than doing it up in the UI, use the "Row Groups" dropdown at the bottom:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. (htt…
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now