Blog Post

Core Infrastructure and Security Blog
3 MIN READ

SSRS Subscriptions (What goes on "under the hood")

TimPlesuk's avatar
TimPlesuk
Icon for Microsoft rankMicrosoft
Mar 15, 2019
First published on MSDN on Jun 20, 2016 One of the more difficult features to understand/troubleshoot that I've found in my experiences working with SSRS customers is the SSRS subscription functi...
Updated Apr 28, 2020
Version 4.0
TimPlesuk
JDAndrew's avatar
JDAndrew
Copper Contributor
May 03, 2022

Hi Tim,

 

I'm trying to find a way around the empty reports problem. 

 

Due to the fact that I have a lot of subscribers to one report, and the parameters determine what and who they go to, a simple query inserted in the job isn't suitable.

 

Given the last thing that happens is the report is emailed, is there somewhere that a "count rows AND if = 0, stop" type statement could be added?

 

I realise I may have to insert it into core code, but I'm hoping there's somewhere in the logic flow between the query to create the report data runs, and when the email is triggered.

It's probably necessary to have more detail when report execution occurs. I can see it counts and stores the count in the execution log, so this must happen during execution some time and can't be after the email is sent, although it could be stored somewhere temporarily possible and then deleted later.

Is there anywhere you can advise to insert such logic?

 

I know it's an old problem that needs a solution.

 

A configuration option would be ideal 🙂

Thanks.

Cheers,


Andrew