Wednesday, March 7, 2012

data-driven subscription not available

I would like to setup a data-driven subscription for a report, but the New
Data-driven Subscription button is not available on the subscription page -
only the New Subscription button appears. I have checked that the report
uses a custom data source and stores the user name and password credentials
in the report server. The account that I am using to access Report Manager
is in the System Administrators role and the Content Manager role for the
report. What am I missing?
Thanks,
RobertDo you have Enterprise Edition? This feature is not available in Standard
Edition.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RMac" <@.news.postalias> wrote in message
news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
>I would like to setup a data-driven subscription for a report, but the New
> Data-driven Subscription button is not available on the subscription
> page -
> only the New Subscription button appears. I have checked that the report
> uses a custom data source and stores the user name and password
> credentials
> in the report server. The account that I am using to access Report
> Manager
> is in the System Administrators role and the Content Manager role for the
> report. What am I missing?
> Thanks,
> Robert|||That is the problem then. I was not aware that Data-driven subscriptions
are not available in Standard Edition. Thanks Jasper.
"Jasper Smith" wrote:
> Do you have Enterprise Edition? This feature is not available in Standard
> Edition.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "RMac" <@.news.postalias> wrote in message
> news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
> >I would like to setup a data-driven subscription for a report, but the New
> > Data-driven Subscription button is not available on the subscription
> > page -
> > only the New Subscription button appears. I have checked that the report
> > uses a custom data source and stores the user name and password
> > credentials
> > in the report server. The account that I am using to access Report
> > Manager
> > is in the System Administrators role and the Content Manager role for the
> > report. What am I missing?
> > Thanks,
> > Robert
>
>