Solved

Ssrs grouping and subtotals

Posted on 2014-02-27
2
2,101 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 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