Ssrs grouping and subtotals

UnderSeven
UnderSeven used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
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.

Author

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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial