SSRS Report Subscription Fails Due to Subscription contains parameter values that are not valid
Question
-
Hi,
I have configured a report in which 4 text data type parameters get values from a dataset query.
The 4 datasets have been configured to pick avg value of a column between the default start date and end date and the average gets calculated alright and is stored at run time in the 4 respective parameters.
However, after subscribing this report for auto-mail, we observed that the mail is not being received to the respective recipients.
So, we went into it & checked the last run status which indicated "The Subscription contains parameter values that are not valid" & the status was of the subscription was automatically disabled.
We would like to hear from you the possible root cause and its best solution to overcome this issue ASAP.
Note*: The values in the average column are always present with a frequency of every minutes.
Attached is the snapshot for your reference.
Please help!!!
Thanks for your support & understanding!
Regards,
Afshaan Shaikh
