Share via

Force Sub Group Header Display Without Sub Group Details

BC 0 Reputation points
2024-02-01T22:18:16.54+00:00

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

 


SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.


2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 41,551 Reputation points
    2024-02-02T06:20:16.25+00:00

    Hi @BC,

    Have you set the textbox property--visible--show the textbox when run the job? User's image

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Was this answer helpful?

    0 comments No comments

  2. BC 0 Reputation points
    2024-02-02T02:42:43.6566667+00:00

    SubReport2of3.png There should be a 3rd block for the 3rd account. Because there were no detailed transaction during the report period it leaves the entire block out. I still want the block header and beginning and ending balances. They will be the same, no transactions.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.