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 -

Entire Report

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

Answers


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.


Need Your Help

Where to properly apply :hover to keep submenu css in the hover state

html css drop-down-menu

I am trying to make drop down menu. Some folks helped me on

Junit testing an Akka singleton actor: preStart() hook not called

java eclipse junit akka

I would like to test a singleton actor using java in Scala IDE build of Eclipse SDK (Build id: 3.0.2-vfinal-20131028-1923-Typesafe) and Akka is 2.3.1.