Does Reporting Services 2000 have data-driven subscriptions or will I need
to upgrade to RS 2005. I would like different employees to pass different
parameters by default. I receive the following message in RS 2000 and I'm
storing a sql account password so I don't think security is the issue.
The error says the following "Subscriptions cannot be created because the
credentials used to run the report are not stored, the report is using
user-defined parameter values"data-driven subscriptions do work in RS 2000. I believe the problem with
your subscription is that one of your parameters is the user login. You are
probably defaulting the current user into the field. You may need to remove
the default value so that you can supply it from the data driven query for
your subscription.
"Colin" wrote:
> Does Reporting Services 2000 have data-driven subscriptions or will I need
> to upgrade to RS 2005. I would like different employees to pass different
> parameters by default. I receive the following message in RS 2000 and I'm
> storing a sql account password so I don't think security is the issue.
>
> The error says the following "Subscriptions cannot be created because the
> credentials used to run the report are not stored, the report is using
> user-defined parameter values"
>
>
