how to enable data driven subscription in ssrs 2017 standard edition ?

2022-02-22T16:38:04.85+00:00

My databased version is Microsoft SQL Server 2017 (RTM-CU28) (KB5008084) - 14.0.3430.2 (X64) standard edition.

Subscription Type is missing in the SSRS subscription.

how to enable data driven subscription in ssrs 2017 standard edition

Thank you

Sathiamoorthy

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,910 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,576 Reputation points
    2022-02-23T01:25:23.11+00:00

    Hi @சத்தியமூர்த்தி இரா ,

    Data-driven subscriptions are available in the Enterprise edition of SQL Server, but not in the Standard edition. See more: SQL Server Reporting Services features supported by editions.

    If you are doing a lot of data-driven report subscriptions, it may be worth your while to pay for that license.

    If you want to implement a function similar to data-driven subscription, you could refer to the following links: Create SSRS Data Driven Subscriptions on Standard Edition.
    Creating Data-Driven SSRS Reports in SQL Server Standard Edition.

    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.