SSRS report email subscription should not be sent, when there is no data in the report

0
votes

SSRS report email subscription should not be sent, when there is no data in the report.

Can anyone please tell me how to do this?

This report doesn't have any parameters. I am using 2016 reporting server.

1
reporting-services
are you using SQL SERVER standard or SQL SERVER Enterprise? You usually use a data driven subscription to get around issues like this.. but unfortunately, only available on the Enterprise version – Harry

1 Answers

1
votes

You will need to use a data-driven subscription. If the query for the instructions for the data-drive subscription does not return a row, no report will be sent. Just base the SQL statement for the data-driven subscription off of the same data from your report.

Link for Ref

Link 2