<div>
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:<br />
<br />
runas /netonly /user:domain\username program.exe
</div>


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

<div>
Jason thx for the reply.<br />
<br />
What you are stating above is regarding running any application as &nbsp;a particular user.<br />
<br />
But what &nbsp;I am looking for is running only SSRS reports and within the report designate <br />
have a user parameter and based on the user he is allowed to see only particular aspects <br />
through security or visibility.<br />
<br />
I am going to keep this ticket as unanswered for now.
</div>


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.

<div>
<div class="content wysiwyg-content">
Current Environment<br />
1. I have a report named ReportA.<br />
2. I have created a linked Report from the ReportA named ReportAL<br />
<br />
I need to allow specific users to view only specific parameters in the parameters drop down.<br />
<br />
Example:<br />
In ReportA I have ParameterA<br />
ParameterA Drop Down List looks like:<br />
<br />
ItemA<br />
ItemB<br />
ItemC<br />
ItemD<br />
<br />
This works well.<br />
However, in the Linked Report ReportAL I would like a specific user to only view:<br />
<br />
ParameterAL Drop Down List to look like:<br />
<br />
ItemA<br />
ItemD<br />
<br />
This is where I need assistance - A User based parameter filter in the report how can I do this?
</div>
</div>


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?

How can I assign parameters by Domain\User

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.