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.