SSRS Split Report By User

Question

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 -

Entire Report

So if Pilar is in the list of recipients that will receive this mail, he should only see the below info.

Guess the email addresses are already stored in a table. Make that a parameter in the report and generate individual reports for individual email addresses — Raj, Apr 06 '16 at 06:50
Data driven subscription if you have Enterprise: https://msdn.microsoft.com/en-au/library/ms169673.aspx else try this answer http://stackoverflow.com/questions/7875827/data-driven-subscriptions-ssrs-standard-edition-2008 — Liesel, Apr 06 '16 at 06:55

score 2 · Accepted Answer · answered Apr 06 '16 at 07:50

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.

SSRS Split Report By User

1 Answers1