Solved

ssrs report grouping question

Posted on 2014-02-28
5
479 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
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
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
Comment Utility
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 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
"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
Comment Utility
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
Comment Utility
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 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

11 Experts available now in Live!

Get 1:1 Help Now