How can I assign parameters by Domain\User

rhservan
rhservan used Ask the Experts™
on
Current Environment
1. I have a report named ReportA.
2. I have created a linked Report from the ReportA named ReportAL

I need to allow specific users to view only specific parameters in the parameters drop down.

Example:
In ReportA I have ParameterA
ParameterA Drop Down List looks like:

ItemA
ItemB
ItemC
ItemD

This works well.
However, in the Linked Report ReportAL I would like a specific user to only view:

ParameterAL Drop Down List to look like:

ItemA
ItemD

This is where I need assistance - A User based parameter filter in the report how can I do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jason clarkDBA Freelancer

Commented:
While there's no way to connect to multiple servers as different users in a single instance of SSMS, what you're looking for is the following RUNAS syntax:

runas /netonly /user:domain\username program.exe

Author

Commented:
Jason thx for the reply.

What you are stating above is regarding running any application as  a particular user.

But what  I am looking for is running only SSRS reports and within the report designate
have a user parameter and based on the user he is allowed to see only particular aspects
through security or visibility.

I am going to keep this ticket as unanswered for now.
DBA Freelancer
Commented:
Here you may find that how to control the dynamically filtering in SQL Server. Please go this one it may be helpful to you. https://www.mssqltips.com/sqlservertip/1743/dynamically-control-data-filtering-in-sql-server-reporting-services-reports/

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial