Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSRS - Insert details section under existing group

  • 10 July 2013
  • Author: Eric D
  • Number of views: 8446
  • 0 Comments

How to add a details section below an already created group.

What I have currently:

/Portals/7/Assets/Uploaded-CMS-Files/pic1-d59f4db7-368e-48f5-b858-b99e74e992a5.png 

And what I would like to have:

/Portals/7/Assets/Uploaded-CMS-Files/pic2-2b4d344f-3e93-4f43-9af6-3ce2e249ba01.png

Here are the steps how to make this happen:

1. Right-click on code_group and add a child group
and specify JobNum, which leaves you at:

/Portals/7/Assets/Uploaded-CMS-Files/pic3-43937e2b-d5f5-4acf-9d56-149cc0467152.png

2. Right-click on JobNum and add an outside row
above group, which leaves you at:

/Portals/7/Assets/Uploaded-CMS-Files/pic4-b10eb684-76be-4171-8a7d-0356c29728d9.png
3. Copy paste Code_Group up one row

4. Right-click on JobNum column and add
Child-group, specifying ‘Show Detail data’, which leaves you at: 

 /Portals/7/Assets/Uploaded-CMS-Files/pic5-fc92662f-d5d6-4bdf-beaf-2a85f60b4749.png 

5. In the Row Groups section, select the drop down
next to the JobNum group and “Delete Group”

6. In the resulting pop-up, select “Delete group
only”

7. Delete the column labeled “Group1”

8. In the resulting pop-up, select “Delete columns
only”, which brings you to the desired state:

/Portals/7/Assets/Uploaded-CMS-Files/pic6-3d74ca84-eacd-4a90-9a7f-556ee04a1237.png
 

 

Print
Tags:
Rate this article:
.5

Eric Dedronen

Other posts by Eric D

Please login or register to post comments.