Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Ssrs grouping and subtotals

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
UnderSeven
Asked:
UnderSeven
1 Solution
 
lcohanDatabase AnalystCommented:
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:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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