in SSRS 2008 r2, I used to be able to create data-driven subscriptions. As a matter of fact I have quite a few reports with and without existing subscriptions that I can use data-driven subscriptions.
Now, after getting the failed error message, I decided to have a very simple query in the report.. something in the line of select top 10 * from ACME.
And using a functional shared data-source.
here it comes.
When I upload this functional report to the server and getting to "manage/subscriptions" I cannot use the data-driven.
The error is :
data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using ser-defined parameter values, or if a linked report, the link is no longer valid.
> do not have parameters
> it is not a link
> using a good valid data-source that 100+ reports are running off of
Any ideas what can cause the server to act up like this?