SSRS Split Report By User
We use SSRS to distribute sensitive information to employees (Commissions, Pay checks etc)
What is the best way to split the report by user without requiring a separate schedule per user?
These are automated to send out, so no user accessing the files from the report server, they only see the email that is sent out.
Example Below -
So if Pilar is in the list of recipients that will receive this mail, he should only see the below info.
You can use SQL Server Reporting Services data-driven subscription as a solution.
If you check the referred Reporting Services example, you take a list of receivers of the report with email address for sending the report via email. You can add this email address or userid as an import parameter to SQL stored procedure which serves the data. You can select NULL values for specific users in the data query.
This method enables SQL developers to create reports tailored for each receiver.