reporting services - Generate Section Trailer with Variable Number of Rows [Report Builder]

Question

I have a report for which I need to get the number of bank accounts of each type for each team in my baseball league. I need a listing of the team, player, and account, with a subtotal footer that gives the counts of each kind of account for each team, like this:

Team	Player	Account
Yankees	Babe Ruth	Savings
Yankees	Lou Gehrig	Other
Yankees	Aaron Judge	Loan
Yankees	Joe DiMaggio	Savings
Yankees	Derek Jeter	Savings

question from:https://stackoverflow.com/questions/66053281/generate-section-trailer-with-variable-number-of-rows-report-builder

Answer 1

To create the Accounts summary section you could use a table. The design would look like this:

This would need to be grouped by the Account column so that there is one row per Account value. You can remove borders and format as needed to make it look how you want.