Tuesday, February 10, 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")

No comments:

Post a Comment

How to Deploy your API as a web app or API app

  Before you can call your custom API from a logic app workflow, deploy your API as a web app or API app to Azure App Service. To make your ...