SSRS - Fail subscription on parameter change
-
Any SSRS experts here?
We have several reports where the possible parameter values are populated by a query. We also have subscriptions with these parameter values preconfigured.
Currently, it seems that whenever changes in a parameter query causes the preconfigured parameter value/s of a subscription to become invalid (e.g. the value doesn't exist anymore), the subscriptions chooses a default value. This has recently caused one subscription to send incorrect information. The request now is for this subscription to completely fail, instead of changing the parameter value. Is this even possible?
-
@Vault_Dweller It's easier than you think. I do not know if any version of the Report Manager has the feature you are looking for, but the simple alternative is to render and deliver the report with a script. Here is an example: https://kohera.be/sql-server/emailing-ssrs-reports-on-a-scheduled-basis-without-using-subscriptions-or-attachments/