Wednesday, January 28, 2015

SSRS - Forcing subreport Contains Empty data / no rows to Show



1.Add a dataset ("dataset2)" in sub report with following query

SELECT ' ' AS DUMMY
 
 
2.Add a empty textbox with following expression
=First(Fields!DUMMY.Value, "DataSet2")
 

Reference:

https://coderwall.com/p/meqrng/forcing-a-ssrs-subreport-to-show


No comments:

Post a Comment