I have a report with sub groups SSRS 2016. It shows the beginning and ending balance for each sub group and totals the ending balances of all the sub groups for a total balance. I can have a sub group without detail transactions. If there are no details it is not displaying the header. I still need the header even though there are no details. In the example below there are two sub groups. The third sub group does not show because there are no transaction in that period. However, the balance for that group still needs to be displayed and totaled. How do I display the header on a group without details?
TO: 3D PRINTED PROSTHETICS CLUB SOA #xxxxx
Beginning Balance: $31,094.65
General 3D PRINTED PROSTHETICS CLUB
General 3D PRINTED PROSTHETICS CLUB Account Beginning Balance $603.67
Payments
Date Check # Ref. Code Ref. # Amount Cleared Expense Code Payee
07/10/23 339992 300.00 Equipment $4999 or Less Brandon Simpson
($300.00) Total Payments: ($300.00)
Transfers Out
Date Document Ref. Code Ref. # Amount Cleared Expense Code
08/01/23 20046 7/10/2023 339992 0.63 Postage Expense
08/10/23 20181 Be Involved Fall 2023 25.00 Event Expense
($25.63) Total Transfers Out: ($25.63)
Transfers In
Date Document Ref. Code Ref. # Amount Cleared Income Code
02/02/23 18773 PESC Merit Fund 450.00 04/06/23 Transfer
03/31/23 19270 $822.04 0.0000724 5.32 05/23/23 Checking Interest
05/15/23 19327 Merit Award PESC 1,500.00 06/27/23 Transfer
$1,955.32 Total Transfers In: $1,955.32
General 3D PRINTED PROSTHETICS CLUB Account Ending Balance $2233.36
3D PRINTED PROSTHETICS CLUB SOGA
3D PRINTED PROSTHETICS CLUB SOGA Account Beginning Balance $30490.98
Payments
Date Check # Ref. Code Ref. # Amount Cleared Expense Code Payee
07/12/23 340021 3D Printer Inv 232111 29,550.00 Equipment $5000 or More MasterGraphics
($29,550.00) Total Payments: ($29,550.00)
3D PRINTED PROSTHETICS CLUB SOGA Account Ending Balance $940.98
Ending Balance: $32,434.62