Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

ssrs report grouping question

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
UnderSeven
Asked:
UnderSeven
  • 3
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
UnderSevenAuthor Commented:
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
 
lcohanDatabase AnalystCommented:
"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
 
UnderSevenAuthor Commented:
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
 
UnderSevenAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now