<div>
From an ASP application?!<br />
the parameter in SSRS is a string like another normal string... <br />
You have a stored procedure in your database that receive the user as parameter and return to the report only the rows that the user can see!<br />
Helped?!<br />
Cheers!
</div>


<div>
No this is from the ReportServer. But my question is how do i pass that Windows Login to the ReportServer as a parameter?
</div>


<div>
Works like a charm. Thanks =)
</div>


<div>
<div class="content wysiwyg-content">
How can i pass a windows login or active directory username as a parameter in SSRS. I have a table with users in the database and based on the roles those users have i need to pass that and show what can be seen on a report.<br />
<br />
How can i do this.<br />
<br />
Thanks
</div>
</div>


How can i pass a windows login or active directory username as a parameter in SSRS. I have a table with users in the database and based on the roles those users have i need to pass that and show what can be seen on a report.

How can i do this.

Thanks

From an ASP application?!
the parameter in SSRS is a string like another normal string... 
You have a stored procedure in your database that receive the user as parameter and return to the report only the rows that the user can see!
Helped?!
Cheers!

No this is from the ReportServer. But my question is how do i pass that Windows Login to the ReportServer as a parameter?

Passing windows login as a paramter in SSRS

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.