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

All Courses

From novice to tech pro — start learning today.