Am receiving the error message "Default value or value provided for the report parameter is not a valid value" when attempting to save a data driven subscription when
choosing to make the reports parameter based on a field returned by the recipient list query for the subscription.
If I choose the option "Specify a static value" the subscription saves fine. I then test it by forcing a report execution snaphot to be generated and the emails are sent out. Unfortunately, the reports are all the same as the parameter is static!
The parameter in question is string and allows nulls and blanks. It used to have a query based list of values, but I got rid of that thinking that was a problem. So now I have a string parameter which technically should accept anything yet I get the error whenever I try and make the subscription substitute the parameter with values from the query.
I already checked the recipient list query and it returns all valid strings.
choosing to make the reports parameter based on a field returned by the recipient list query for the subscription.
If I choose the option "Specify a static value" the subscription saves fine. I then test it by forcing a report execution snaphot to be generated and the emails are sent out. Unfortunately, the reports are all the same as the parameter is static!
The parameter in question is string and allows nulls and blanks. It used to have a query based list of values, but I got rid of that thinking that was a problem. So now I have a string parameter which technically should accept anything yet I get the error whenever I try and make the subscription substitute the parameter with values from the query.
I already checked the recipient list query and it returns all valid strings.