asked on
Passing windows login as a paramter in SSRS
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
How can i do this.
Thanks
Microsoft SQL Server 2005
Last Comment
zx10r
ASKER
No this is from the ReportServer. But my question is how do i pass that Windows Login to the ReportServer as a parameter?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Works like a charm. Thanks =)
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!