How to make subreports always display?

• Friday, March 16, 2012 3:44 PM

   

   
  

  0

  I designed an RDL file which contains several subreports within a Tablix.  What I want this report to do is always display the subreports, regardless if the main report has any data.  These subreports are not subsets of the output data from the main report, but rather they use the same input parameters as the main report.  That is why there are cases where the subreports contain data and main reports do not.  How do I do this in SSRS 2008?

  I tried implementing this and I get an out of memory exception error.  What I did was I placed the subreports outside of the tablix and encapsulated both the tablix and subreports into a List.  Next I fed the same input parameters to these subreports as before and I created this dataset for the List control:

  ALTER Procedure [dbo].[rpt_rd_Lookup_Clients2_FC]
  (
  	@IncludeAllOption bit = 0,
  	@FundingSource varchar(MAX) = null
  )
  As
  
  SET NOCOUNT ON
  
  If @IncludeAllOption = 1
  BEGIN
  	Select
  		Null As [people_id],
  		'-All-' As [insured_name]
  	UNION ALL
  	SELECT DISTINCT
  		bac.[people_id],
  		bac.[insured_name]
      FROM benefits_assignments_clients_view bac    
      left join enrollment_info_expanded_view eiev on eiev.people_id = bac.people_id
  	WHERE payer_name like 'GA-%' and program_code = 'INT'
  	AND (@FundingSource Is Null OR (@FundingSource like bac.payer_name + '%' and @FundingSource like '%' + plan_name))
  	Order By [insured_name]
  END
  Else
  BEGIN
  	SELECT DISTINCT
  		bac.[people_id],
  		bac.[insured_name]
      FROM benefits_assignments_clients_view bac    
      left join enrollment_info_expanded_view eiev on eiev.people_id = bac.people_id
  	WHERE payer_name like 'GA-%' and program_code = 'INT'
  	AND (@FundingSource Is Null OR (@FundingSource like bac.payer_name + '%' and @FundingSource like '%' + plan_name))
  	Order By [insured_name]
  END

  And I already tried creating a multiple-value parameter for this report, and then define the filter like this:

  Expression: Parameters!ClientID.Value
  Operator: In
  Value:[people_ID]

  But this gave me the error:

  

  

  ---

  Ryan D

  • Reply
  • Quote