?
Solved

ssrs report grouping question

Posted on 2014-02-28
5
Medium Priority
?
500 Views
Last Modified: 2014-03-03
Hello,

I need to group a report in a way that looks like this

Account|GL|Amount
X              X    X
               TOTAL X
X              X    X
                X    X
                Total  X

I know that I can get ssrs to build something similar with report builder, but I don't know how to do it so that the unique GL field will appear on the same line as account if the account only has one instance.
0
Comment
Question by:UnderSeven
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39895562
Did you grouped by account in Report builder?
You need to add grouping by account and have a subtotal line in your report for that group.
In Report Builder if you create a group within the report, SSRS automatically adds subtotals for the groups. Just make sure the "Show Subtotals" option is selected when you right click on the group row in design view.
0
 

Author Comment

by:UnderSeven
ID: 39895649
Hi, so that mostly works, the problem I am having is the sub total it creates goes on the same line as the account, but not at the bottom.  Can I put the sub total outside of the parent group or do I need to add a row that is inside the parent group, but not the details group for the subtotal?  I'm not sure if report builder is capable of building this exactly this way
0
 
LVL 40

Accepted Solution

by:
lcohan earned 1500 total points
ID: 39895711
"Can I put the sub total outside of the parent group"
Do you mean the Grand Total of all accounts? That should be outside if you added it to the report. The subtotal per Account must be shown as a line after that "account group"
0
 

Author Comment

by:UnderSeven
ID: 39896156
I mean the line subtotal.  It is going like this

Account            sub total of all gl amounts
                Gl     individual gl amount
                Gl     individual gl amount

I'd like to move that sub total to the bottom of so it would look like this

Account   Gl     individual gl amount
                Gl     individual gl amount
                             sub total of gl accounts
0
 

Author Closing Comment

by:UnderSeven
ID: 39900718
I just needed to put another row outside group to be able to sub total on the initial group by after the detail section
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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month12 days, 11 hours left to enroll

777 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