[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSRS 2008 add additional group

Posted on 2014-07-15
1
Medium Priority
?
318 Views
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.)
C--Users-csf-Desktop-SSRS-add-group.docx
0
Comment
Question by:cindyfiller
1 Comment
 
LVL 14

Accepted Solution

by:
Russell Fox earned 2000 total points
ID: 40198208
Rather than doing it up in the UI, use the "Row Groups" dropdown at the bottom:
RowGroups.JPG
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

834 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