Solved

ssrs report grouping question

Posted on 2014-02-28
5
484 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
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 39

Accepted Solution

by:
lcohan earned 500 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 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

20 Experts available now in Live!

Get 1:1 Help Now