Improve company productivity with a Business Account.Sign Up

x
?
Solved

Ssrs grouping and subtotals

Posted on 2014-02-27
2
Medium Priority
?
2,438 Views
Last Modified: 2014-02-27
I need to make a sub total line appear every so often in an ssrs report.  The report will include an account number which may be repeated, a gl code which will not be an and amount paid.  After each account has listed each gl code and amount paid I would like it to subtotal that accoutns totals before moving on.  How is this accomplished?
0
Comment
Question by:UnderSeven
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39893124
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 Closing Comment

by:UnderSeven
ID: 39893145
This is easier than trying to figure it out myself and I can use the report builder report to figure out how they did it.  Thanks.
0

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.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Go through the video which explain the procedure to export Amazon WorkMail single or multiple mailboxes to Outlook with Kernel Export Amazon WorkMail to PST tool. User can see the simple steps to export. It has salient features like filters (Include…

579 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