Dynamic report subscription

Eshwar 196 Reputation points
2020-11-17T12:19:45.557+00:00

HI Team,
I am trying to create a report and subscribe that can generate separate output for each of the value in the parameter/something.

Like I want to generate report (through subscription) output for each state dynamically.

Please guide me to right path.

Thanks & Regards,
Eshwar.

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,808 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2020-11-18T02:01:10.19+00:00

    Hi @Eshwar ,
    According to your description, you could try to select Data-Driven Subscriptions.
    Data-driven subscriptions provide a way to use dynamic subscription data, which is retrieved from external data sources at runtime. Data-driven subscriptions can also use static text and default values specified when the subscription is defined. For more information about Data-Driven subscriptions, please refer to: Data-Driven Subscriptions.
    You could also set up your own Data-Driven Subscriptions by Create, Modify, and Delete Data-Driven Subscriptions, and Create a Data-Driven Subscription (SSRS Tutorial) in detail.
    Hope this helps.
    Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    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

0 additional answers

Sort by: Most helpful