CODEWITHSUNDEEP
sql-serverreporting-services
Antonio
Antonio

Reputation: 535

Cannot create Data-Driven subscriptions SSRS (rsHasUserProfileDependencies)

I have created a report (with parameters) that uses two subreports and pass parameters to them.

I want to create a data-driven subscription for the report. But I still get a "yellow alert" on the "create data-driven subscription" menu.

-I have stored credentials on my Data Source (and other reports use the same Data Source and can be data-driven)

-The report has 2 date parameters and a string parameter used in the query

-The report doesn' t have a linked report

-I am not using anything related to the !User object like userid or language...

what can be still causing the issue?

Upvotes: 0

Views: 1636

Answers (2)

Stuart Steedman
Stuart Steedman

Reputation: 257

Data-Driven Subscriptions are not available in the Standard Edition of SQL Server. Upgrading to Enterprise edition (with new licence key) solved the issue.

Upvotes: 0

Antonio
Antonio

Reputation: 535

IT looks like I solved my own question. Error message is quite misleading, it tells you about parameters, but have a look to your report variables as well...

I had mistakenly left an empty report variable, removing it solved the problem..

Upvotes: 1

Related Questions