How can I create and email a data-driven subscription for each collaborator using SSRS?

Question

Hi, I need help please.

Currently, I have a (fictitious) report for each member of my sales team. When I create a data-driven subscription and send it to each team member's email, instead of everyone receiving their own report, everyone receives everyone else's report.

My goal is that if my team consists of 10 people, each person will individually receive their own report in PDF format. I already have the report published in SSRS (version 15.0.1102.1084) and it is separated by ID, name, etc., and email for each person.

Could you please guide me on how I can set this up so that each team member receives only their own report?

Please refer to the following information:

https://learn.microsoft.com/en-us/sql/reporting-services/create-a-data-driven-subscription-ssrs-tutorial?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/reporting-services/create-a-data-driven-subscription-ssrs-tutorial?view=sql-server-ver16#create-a-data-driven-subscription-ssrs-tutorial

I extract information from an SP:

ALTER PROCEDURE [dbo].[GetProviders]. AS BEGIN SELECT [IDProvider] ,[Name] ,[Contact] ,[Phone] ,[Email] FROM [Suppliers].[dbo].[Suppliers] END

In visual studio (version 2022):

I added to the report a list, in the list I added text boxes and some with expressions, then a table. At the end there is one report per co-worker, in total 10, but when I make the subscription those 10 reports are sent to each co-worker and I need that each co-worker receives only the report that corresponds to him.

In SSRS I have changed the parameters:

I have tried to change the SP of sql, also add groups in visual studio and read several ways to make a subscription, but so far without the effect I am looking for.

Answer 1

Hi @Victor Pimentel

If you want to get different information based on different users, then you need to create parameters in the report for filtering.

For example, if you add a condition "where Email in (@EmailPara)" to the query in the report, this will create a parameter "EmailPara" through the field email and filter the report results through the parameter.

Then the parameters section will appear on the subscription page. In the EmailPara field, select Get value from dataset. In Value, select Email.

This part of setting parameters also has steps in the tutorial, you can check these steps carefully: https://learn.microsoft.com/en-us/sql/reporting-services/lesson-2-modifying-the-report-data-source-properties?view=sql-server-ver16#bkmk_add_reportparameter.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya