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.
UnderSevenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.